tag:blogger.com,1999:blog-8950887269244304313.post3323752104192645497..comments2024-03-15T02:17:39.656-05:00Comments on Adventures in Database Administration: Dynamic Connection Strings in SSISKevinhttp://www.blogger.com/profile/09120001050238915178noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-8950887269244304313.post-88882888101137285782019-10-24T18:27:51.383-05:002019-10-24T18:27:51.383-05:00the result is 0 as it is the object returned. If y...the result is 0 as it is the object returned. If you had a more than one thing coming back it would be 1, then 2... its zero based. Hope that helps :)Ryanhttps://www.blogger.com/profile/11261098696710904703noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-43246426507190359292019-10-24T18:25:53.405-05:002019-10-24T18:25:53.405-05:00try putting in a default value in your variable fo...try putting in a default value in your variable for your database - it will replace it when it runs. make sure its a database on network and not the local one. (that got me for a awhile)Ryanhttps://www.blogger.com/profile/11261098696710904703noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-63835845330575217692019-10-24T18:24:35.646-05:002019-10-24T18:24:35.646-05:00perhaps a script function to verify if the server ...perhaps a script function to verify if the server is online prior to performing your logic. I would also log that it was offline at the time to let you know it didn't run for that reason, CheersRyanhttps://www.blogger.com/profile/11261098696710904703noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-748540768301533162019-10-24T18:23:28.518-05:002019-10-24T18:23:28.518-05:00This comment has been removed by the author.Ryanhttps://www.blogger.com/profile/11261098696710904703noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-52087633377588611362015-12-23T23:33:00.077-06:002015-12-23T23:33:00.077-06:00Hello...
Thanks... please help me how to avoid fa...Hello...<br /><br />Thanks... please help me how to avoid failing the package when any DB server not able to connect with Dynamic String Connection ... in my case I have 40 servers when any of server not running my package giving me error and getting failed... is there any way to bypass db connection string when the server down..Anonymoushttps://www.blogger.com/profile/02402550205250046052noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-3552297688271837122013-04-10T12:22:19.540-05:002013-04-10T12:22:19.540-05:00Excellent! Thank you Kevin...I keep forgetting to ...Excellent! Thank you Kevin...I keep forgetting to change the expression on the connection. All better now!Emeryhttps://www.blogger.com/profile/15117376138477752054noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-38758017833963259092012-11-20T15:09:48.479-06:002012-11-20T15:09:48.479-06:00in DB2?in DB2?Alberto Almario Valbuenahttps://www.blogger.com/profile/16309883559751024062noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-50700991088315545372012-09-20T09:37:36.187-05:002012-09-20T09:37:36.187-05:00I don't believe you can do that since there is...I don't believe you can do that since there is no way to map the individual columns on the fly.Kevinhttps://www.blogger.com/profile/09120001050238915178noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-72045378765327703272012-09-19T16:56:43.499-05:002012-09-19T16:56:43.499-05:00Can we set the destination connection string dynam...Can we set the destination connection string dynamically for Bulk insert? I need to change the destination connection string and destination table dynamically.<br /><br />Thanks,surenderhttps://www.blogger.com/profile/09323712506447223380noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-23529023552851756462012-07-31T03:32:35.336-05:002012-07-31T03:32:35.336-05:00Hi,
I am also facing the same problem as "Un...Hi,<br /><br />I am also facing the same problem as "Unknown" is facing. I implemented the same scenario but when package runs it fails with error "Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ConnectAzure" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed."<br /><br />Did you face this problem? If yes then please guid us about how to resolve it.Chetanhttps://www.blogger.com/profile/15098675979521043010noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-36856716716779936582012-07-08T20:23:30.536-05:002012-07-08T20:23:30.536-05:00hi, im the same guy again :). Look when i was able...hi, im the same guy again :). Look when i was able to set up the connection string successfully but when im within the data flow and i want to query a random table using the connection string created ive got a massive error saying "DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER" do you know how to solve this?Unknownhttps://www.blogger.com/profile/13192163689837516449noreply@blogger.comtag:blogger.com,1999:blog-8950887269244304313.post-8998681885527256222012-07-08T18:16:00.051-05:002012-07-08T18:16:00.051-05:00Why do you assign the Result Name as 0? can i just...Why do you assign the Result Name as 0? can i just name it Connenction String and still be able to use it throughout the connection managers' string'?<br />Thanks very much for your post!Unknownhttps://www.blogger.com/profile/13192163689837516449noreply@blogger.com