Scenario 18: Produce files as target with dynamic names
Scenario18 :How to generate file name dynamically with name of sys date ? How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.
April 18th, 2011 3:41am

use an expression on the Connection Manager. Search this forum for more details... it's a common question.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 3:44am

this is a brief sample: http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.htmlhttp://www.rad.pasfu.com
April 18th, 2011 3:46am

You could also use script task to dynamically change the file name or the connection string of the file.Request to please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 4:00am

I asked nearly 20 questions here.... But each solution is having "Script Task" or "Script Component"..? But I dont know Visual Basic.Net programming(or Script)....... So what should I do... is there any free book to learn writing/learning VB.net breifly....?
April 22nd, 2011 11:45am

I asked nearly 20 questions here.... But each solution is having "Script Task" or "Script Component"..? But I dont know Visual Basic.Net programming(or Script)....... So what should I do... is there any free book to learn writing/learning VB.net breifly....? For the 'special things' you often have a choice between custom components from for example codeplex or some Scripts from the various blogs. Most of the Script examples are ready to use. Just copy and paste it. And if you really want to learn a programming language, its better to learn C# although VB.net is probably a little easier to learn.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2011 1:16pm

I asked nearly 20 questions here.... But each solution is having "Script Task" or "Script Component"..? But I dont know Visual Basic.Net programming(or Script)....... So what should I do... is there any free book to learn writing/learning VB.net breifly....? This is because Scripting is one of most powerful features of SSIS, you can do anything you want as source/transformation/destination in data flow tasks with resort of script component . You don't need to know much VB.NET or C#, just few lines of codes you need to write. I recommend you to read msdn articles about script component and you will be familiar with this scripting easily: http://msdn.microsoft.com/en-us/library/ms137640.aspx http://msdn.microsoft.com/en-us/library/ms136118.aspx http://msdn.microsoft.com/en-us/library/ms136116.aspxhttp://www.rad.pasfu.com
April 22nd, 2011 3:01pm

Thanks Reza Raad and SSISJoost
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2011 4:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics