Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSIS - Create Folder Dynamically

  • 12 July 2012
  • Author: mmabdulkadir
  • Number of views: 4375
  • 0 Comments

Hi All,

i have set the variable for drive..

 now i want  the how to store the object variable.. because i have stored theJurisID value in one object variable.

 i have used the OLEDB Source ,RecordSet Destination..

 OLE DB Source - Select JurisID from Juris

 RecordSet Destination - Variable - User::Name

 this User:Name- variable is the data type object..

 then, ForEach Loop - ADO Enumerator

 ADO Object variable Name - USER::Name -- this is object variable..

 Now, i want this type,  C:\Conversion\JurisID\Attachments and

 C:\Conversion\JurisID\Image .

how to display the JurisID values replaced by the JurisID folder..

JurisID Column contains the 1000,1001,1002,1003 ..

 
i want this type result, 

C:\Conversion\1000\Attachments

C:\Conversion\1000\Image

 
C:\Conversion\1001\Attachments

C:\Conversion\1001\Image

 
C:\Conversion\1002\Attachments

C:\Conversion\1002\Image

 
C:\Conversion\1003\Attachments

C:\Conversion\1003\Image

 any one help me..

Thanks,

Abdul Khadir.

Print
Tags:
Rate this article:
No rating

mmabdulkadirmmabdulkadir

Other posts by mmabdulkadir

Please login or register to post comments.