tag:blogger.com,1999:blog-29438013.post116927659532629015..comments2023-07-01T07:07:08.839-04:00Comments on Rafael Salas: SSIS Package Configurations using SQL Server table...an alternative to the Indirect methodRafa Salashttp://www.blogger.com/profile/16375071697865176825noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-29438013.post-14377154866528862812014-01-22T23:07:24.560-05:002014-01-22T23:07:24.560-05:00In sql server Configuration approach discussed abo...In sql server Configuration approach discussed above No where in the SSISConfig table the name of the package is stored to uniquely identify it.So shall I have to create 10 diff SSISConfig tables for deploying 10 diff diff Master packages??<br /><br />Thanks & Regards, ShovanAnonymoushttps://www.blogger.com/profile/12066190796745934108noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-30129853251158257272011-09-12T06:17:24.326-04:002011-09-12T06:17:24.326-04:00"Just in case, the value for the SSIS_Config ..."Just in case, the value for the SSIS_Config is just a connection string that can be consumed by the connection manager; something like:<br /><br />Provider=SQLNCLI.1;Data Source=MARINERLAPTOP14;Integrated Security=SSPI;Initial Catalog=ETLRafLabDev"<br /><br />Can we also give SQL Server username and password in the windows environmental variable?Pramod palurinoreply@blogger.comtag:blogger.com,1999:blog-29438013.post-67533748734396830052011-01-19T00:14:44.893-05:002011-01-19T00:14:44.893-05:00Good article. Just what I needed :-)Good article. Just what I needed :-)Kabirhttps://www.blogger.com/profile/13413016504372063407noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-38344674471955517462011-01-17T13:33:05.207-05:002011-01-17T13:33:05.207-05:00Hi Rafael,
I used exactly the method you outlined ...Hi Rafael,<br />I used exactly the method you outlined here, but when using the pacakge from a SQL agent job, I find that the package does not use the Configuration table values at all. Any idea what might be missing? Could this be a permission issue?Saugathttps://www.blogger.com/profile/11451425599731336320noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-1448899509923750552009-10-31T03:20:37.066-04:002009-10-31T03:20:37.066-04:00n u send copy 2 me
sikandar@sris-global.comn u send copy 2 me<br />sikandar@sris-global.comMohammed Sikanderhttps://www.blogger.com/profile/13771688313878241374noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-77207817112347323472009-09-30T09:57:16.055-04:002009-09-30T09:57:16.055-04:00Rafael, Is it possible to add encryption in this p...Rafael, Is it possible to add encryption in this process, i.e. it would be nice to have the passwords for DB connections encrypted ?Unknownhttps://www.blogger.com/profile/01030766447716486564noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-73936732043388371752009-09-22T01:57:22.261-04:002009-09-22T01:57:22.261-04:00Hi Rafael,
Could you please send me a copy of the...Hi Rafael,<br /><br />Could you please send me a copy of the package. <br /><br />More over i have an issue. Currently we are migrating our 2005 packages to 2008. All the package does not use all the connection from the configuration. This works fine in 2005. Where as in 2008 i am getting connection collection error. how to resolve this issue. Can you please me. Mail me at preerathi@yahoo.com<br /> <br />thanks.....PreethiPreerathihttps://www.blogger.com/profile/04302333352649100482noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-86896086463174028332009-08-27T10:16:28.727-04:002009-08-27T10:16:28.727-04:00In my situation, my dev and qa instances are on th...In my situation, my dev and qa instances are on the same physical server. Can I use this approach?Bill Ohttps://www.blogger.com/profile/00657145522910938555noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-24349344799528037392009-07-29T10:37:13.813-04:002009-07-29T10:37:13.813-04:00This is all very nice, and there's tons of art...This is all very nice, and there's tons of articles out there on how to create SQL and other package configurations to make your packages portable, but in weeks of searching I haven't found a single thread explaining how to use the variable back in your package!<br /><br />I have a package-scoped variable, User::FolderName that obviously should read the folder name from the package configuration. My SQL package config contains the value (the folder name) I want to use. But, User::FolderName is always blank when I try to run my package.<br /><br />How the **** do you set your package variable to the value in the package config!?Larryhttps://www.blogger.com/profile/13689674373344199903noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-60805398225123439802009-01-27T01:01:00.000-05:002009-01-27T01:01:00.000-05:00it very useful website design New York City we...it very useful <BR/><BR/><BR/><BR/><A HREF="http://www.atozsolution.com" REL="nofollow"> website design New York City </A><A HREF="http://www.atozsolution.com" REL="nofollow"> website design nyc </A>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-29438013.post-91241295055354469372008-12-09T23:21:00.000-05:002008-12-09T23:21:00.000-05:00Hi Rafael,Wonder if you ever uploaded the file? It...Hi Rafael,<BR/><BR/>Wonder if you ever uploaded the file? It's hard to view the setup from this link, thanks.<BR/><BR/>Chrischrisscleehttps://www.blogger.com/profile/16543828616522943357noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-75566469994945561712008-09-22T15:06:00.000-04:002008-09-22T15:06:00.000-04:00Hi Rafael,Can you please send a copy of the packag...Hi Rafael,<BR/><BR/>Can you please send a copy of the package or configuration files to email splee1987@hotmail.comTasteBudhttps://www.blogger.com/profile/02598098567747907688noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-83992353186570034142008-09-09T12:13:00.000-04:002008-09-09T12:13:00.000-04:00Did you Import/Deploy that package to another serv...Did you Import/Deploy that package to another server? If so which one did you use, and did it pickup the EV if you try to run that SSIS package from within Managment Studio?Eric Backscheiderhttps://www.blogger.com/profile/11252716454107333784noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-74101377552378041892008-07-11T06:50:00.000-04:002008-07-11T06:50:00.000-04:00Ive just found the problem. I havent restarted Vis...Ive just found the problem. I havent restarted Visual Studio. Now it works, thanks!Bruno R C Magalhaeshttps://www.blogger.com/profile/04532967087639491145noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-16594927243598121122008-07-11T05:44:00.000-04:002008-07-11T05:44:00.000-04:00I keep trying this approach but I have a problem b...I keep trying this approach but I have a problem because my SSIS connection string value is not set as the environment variable, dont know why..<BR/>Can I get a copy of that package please? quimera [at] gmail [dot] comBruno R C Magalhaeshttps://www.blogger.com/profile/04532967087639491145noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-7457905153990610162007-10-26T19:26:00.000-04:002007-10-26T19:26:00.000-04:00Could I also have a copy of this package please?Or...Could I also have a copy of this package please?<BR/>Or could someone tell me how to create a Connection Manager once I have this SSIS_Config env. variable and the SSIS Configurations table?<BR/>I am just starting with SSIS.<BR/>Thank you.<BR/>Mariola, e-mail mgburzyn@ca.ibm.comMariolahttps://www.blogger.com/profile/07478124035337856987noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-8488739684726792802007-08-10T11:19:00.000-04:002007-08-10T11:19:00.000-04:00I would like a copy of this package please.I would like a copy of this package please.Unknownhttps://www.blogger.com/profile/04903368703319387823noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-47567700385954195822007-04-26T09:16:00.000-04:002007-04-26T09:16:00.000-04:00That is true; this approach does not fit very well...That is true; this approach does not fit very well when you have multiple instances in the same server; and to be honest I don't see a clean way to implement a solution under that scenario. I have worked in projects where my Dev and QA environments were on the same server; I ended up using a virtual server to get a clear separation of the environments; not always an option though .Thanks for pointing that out.Rafa Salashttps://www.blogger.com/profile/16375071697865176825noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-49113603196336873442007-04-25T18:42:00.000-04:002007-04-25T18:42:00.000-04:00We're using that approachJust one thing to note th...We're using that approach<BR/>Just one thing to note though in that if you have a server with multiple SQL Server instances installed this approach does not allow you to port the packages between instances as you'd either have to have instance specific names for the environment variable or face a conflict on it's usageAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-29438013.post-41117624551126792872007-04-23T12:45:00.000-04:002007-04-23T12:45:00.000-04:00Hi Rafael,Can u also send me a copy?arthur@euclide...Hi Rafael,<BR/><BR/>Can u also send me a copy?<BR/><BR/>arthur@euclides.nl<BR/><BR/>Thx in advanceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-29438013.post-63751040070580386862007-04-20T09:28:00.000-04:002007-04-20T09:28:00.000-04:00Hi Rafael,I would also like to have a copy of this...Hi Rafael,<BR/><BR/>I would also like to have a copy of this package (if possible).<BR/><BR/>If you could send me the package at the following address: fofaucher@gmail.com <BR/>I would appreciate!<BR/><BR/>Thanks<BR/>FOAnonymoushttps://www.blogger.com/profile/13023588238128048477noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-54369212151372070452007-04-20T08:11:00.000-04:002007-04-20T08:11:00.000-04:00Silaphet,I am traying right now to find a place to...Silaphet,<BR/>I am traying right now to find a place to upload the files. If you email me I will forward a copy of the package.Rafa Salashttps://www.blogger.com/profile/16375071697865176825noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-73033575508106157762007-04-10T22:35:00.000-04:002007-04-10T22:35:00.000-04:00Hi Rafael,Is that possible to make all your packag...Hi Rafael,<BR/><BR/>Is that possible to make all your packages downloadable?<BR/><BR/>Thanks,<BR/>Silaphet,Anonymousnoreply@blogger.com