How to generate base folder path in ssis

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Abhijit More SSCertifiable Points: 6897 More actions · Answer 1

Can you elaborate more what exactly yu are trying to do?

Abhijit - http://abhijitmore.wordpress.com

inampudianil Ten Centuries Points: 1274 More actions · Answer 2

Hey,

I guess in the script task under C# language add the script

string path = System.Windows.Forms.Application.StartupPath;

Dts.Variables["User::Root_path"].Value = path;

MessageBox.Show(Dts.Variables["User::Root_path"].Value.ToString());🙂

and then create a SSIS variable and aassing the script to the ssis variable

I hope this helps...

Thanks

Anil Inampudi

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

jyothi_siri2000 (1/28/2011)
How to generate base folder path in which it contains source files,ssis solution explorer path , error files in ssis

If you operating system is windows:

navigate to the desired location with windows explorer, right-click on the screen, choose new and then folder.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

pmm.sudarsan Old Hand Points: 370 More actions · Answer 4

You option in the FILE SYSTEM task where you create a folder or file.