InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:57:32 GMT20http://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxIve 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 crossedThu, 21 Feb 2013 07:08:04 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxNot 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 stuffThu, 21 Feb 2013 06:58:11 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspx[quote][b]Debbie Edwards (2/21/2013)[/b][hr]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[/quote]So all sorted now?Thu, 21 Feb 2013 06:54:38 GMTSceloMhttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxJust 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 youThu, 21 Feb 2013 06:53:07 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxIve 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 timeThu, 21 Feb 2013 06:51:05 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspx[quote][b]Debbie Edwards (2/21/2013)[/b][hr]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 messageAttempt 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.[/quote]Try "\\D-fs11\\example-it\\PROJECTS\\DATA WAREHOUSING\\Extract_To_CSV\\" +@[User::CODE_NAME_DATE_File_Name]+".csv"Thu, 21 Feb 2013 06:50:15 GMTSceloMhttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspx[quote][b]Debbie Edwards (2/21/2013)[/b][hr]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 messageAttempt 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.[/quote]I don't think so. Could it be that single backslash characters are causing an issue? (You may need to double them up.)Thu, 21 Feb 2013 06:46:28 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxExcellent 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 messageAttempt 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.Thu, 21 Feb 2013 06:43:00 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxIn case someone may need this in future.I found a solution to my problem from this site [url]https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/[/url].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.Wed, 20 Feb 2013 01:40:47 GMTSceloMhttp://www.sqlservercentral.com/Forums/Topic1421627-364-1.aspxHi allCan 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 [url]http://www.devtechie.com/post/2012/02/29/Export-Data-into-multiple-Excel-file-SSIS.aspx[/url] 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.Tue, 19 Feb 2013 06:58:28 GMTSceloM