Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swapna331
Starting Member
2 Posts |
 Posted - 2011-01-06 : 10:23:31
|
| hi, i had different sources in one folder.. example source1,source2,source3,source4.... same metadata to all the sources.in ssis package i want ole db destination where it will automatically created the destinations.mapping also done for this destination.destination name should be sourcename_todays date.please me some solution to this............ |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-06 : 16:13:55
|
For SSIS you can Create a string variable scoped to the package. In the destination connection properties, you can specify this variable to populate the actual connection.You can use a script task to build the string and also use the resulting variable to generate new folders.in SQL 2000 DTS, you can have a Global Variable do something similar if you for some reason still have only SQL 2000.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
swapna331
Starting Member
2 Posts |
Posted - 2011-01-06 : 23:42:10
|
| im using 2005....... tell me clearly how to get solution to the above. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-07 : 07:34:52
|
Oh , well in that case, here is all the code you need, debugged and ready to run on your system.....oops..no, not really.You can use variables in SSIS, as well as "for each" sequence containers to loop through source/destination components. However, if the column mappings change, that is a much bigger fish to fry, and you best be prepared to do some heavy scripting. The components themselves do not allow for runtime configuration of column mapping metadata.Configuring the Oledb destination (if that is the only thing that needs to change, specifically the folder name) to be dynamic using a variable is pretty easy and basic. Any entry level programmer could figure it out in SSIS in about 5 minutes.http://msdn.microsoft.com/en-us/library/ms141085.aspx
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
|
|
Dynamic OLE DB Destination