February 19, 2013 at 6:58 am
Hi all
Can someone please help me with a link that has an example on how to export data to multiple Excel files.
Files will be created for different department.
I have looked at the example obtained here http://www.devtechie.com/post/2012/02/29/Export-Data-into-multiple-Excel-file-SSIS.aspx but I get an error about the DepartmentReport table already existing, tried to add a File System Task but I am still struggling.
Will appreciate any assistance.
February 20, 2013 at 1:40 am
In case someone may need this in future.
I found a solution to my problem from this site https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/.
A great article in there and I created a package based on it and it worked.
Just one thing though, when creating the JobTitle variable do not put the double quotes in the Value field, just leave the Value field blank.
February 21, 2013 at 6:43 am
Excellent piece and its helped me figure out my problem with adding the files to a folder.
My problem is that my folders arent on the C drive but they are in a specific folder.... e.g.
And when I add this to the connection string like it says in the documentation
"C:\\DataFiles\\" + @[User::JobTitle] + ".csv"
But this instead.....
\\D-fs11\example-it\PROJECTS\DATA WAREHOUSING\Extract_To_CSV+@[User::CODE_NAME_DATE_File_Name]+".csv"
I get an error message
Attempt to parse the expression failed. The toke "\" at line number 0 was not recognised. Im beginning to think that you have to add all the folders for this to the C Drive only.
February 21, 2013 at 6:46 am
Debbie Edwards (2/21/2013)
Excellent piece and its helped me figure out my problem with adding the files to a folder.My problem is that my folders arent on the C drive but they are in a specific folder.... e.g.
And when I add this to the connection string like it says in the documentation
"C:\\DataFiles\\" + @[User::JobTitle] + ".csv"
But this instead.....
\\D-fs11\example-it\PROJECTS\DATA WAREHOUSING\Extract_To_CSV+@[User::CODE_NAME_DATE_File_Name]+".csv"
I get an error message
Attempt to parse the expression failed. The toke "\" at line number 0 was not recognised. Im beginning to think that you have to add all the folders for this to the C Drive only.
I don't think so. Could it be that single backslash characters are causing an issue? (You may need to double them up.)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 21, 2013 at 6:50 am
Debbie Edwards (2/21/2013)
Excellent piece and its helped me figure out my problem with adding the files to a folder.My problem is that my folders arent on the C drive but they are in a specific folder.... e.g.
And when I add this to the connection string like it says in the documentation
"C:\\DataFiles\\" + @[User::JobTitle] + ".csv"
But this instead.....
\\D-fs11\example-it\PROJECTS\DATA WAREHOUSING\Extract_To_CSV+@[User::CODE_NAME_DATE_File_Name]+".csv"
I get an error message
Attempt to parse the expression failed. The toke "\" at line number 0 was not recognised. Im beginning to think that you have to add all the folders for this to the C Drive only.
Try "\\D-fs11\\example-it\\PROJECTS\\DATA WAREHOUSING\\Extract_To_CSV\\" +@[User::CODE_NAME_DATE_File_Name]+".csv"
February 21, 2013 at 6:51 am
Ive had an better error message telling me the example same thing so at least thats something to go on!
Still I tried doubling up \\\\ and got the same error message.
Hmmmmm. Such a tiny part of it. So annoying when these things take up so much time
February 21, 2013 at 6:53 am
Just realised I have been an idiot on this one!
I blame my smaller screen and terrible eyesight :blush:
Of course thats what was meant!
Thank you
February 21, 2013 at 6:54 am
Debbie Edwards (2/21/2013)
Just realised I have been an idiot on this one!I blame my smaller screen and terrible eyesight :blush:
Of course thats what was meant!
Thank you
So all sorted now?
February 21, 2013 at 6:58 am
Not yet...
I have another error message about
The token [The symbol for square] at line number zero
....
Im imagining this is because I have spaces in the folder names that I will need to replace with another symbol. This is just a guess though.
Difficult to find documentation about this stuff
February 21, 2013 at 7:08 am
Ive been a bit daft again. I already have a variable with the folder in.
Ive concatenated this and the file name together to get the whole shebang.
@[Extract_To_CSV_Folder]+@[User::DFES_NAME_DATE_File_Name]+".csv"Hopefully this will work.
Fingers crossed
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply