OK,

I have a temp table of codes (Specified above)

Then I have a query that uses the code as critera so I am going to have another temp table for each...

Abu Dina (2/25/2013)

---

You can copy the result of the below and run in a new sql session:

with cte_MyCodes(Code)

as (select 'A' union ALL select 'B' union all select 'P' union all...

Eugene Elutin (2/25/2013)

---

To create the number of tables dynamically you will need to use dynamic sql (using sp_executesql or EXEC ()). However, it will not work for you, as temp...

Your Full File Name made me realise where I was going wrong. Thank you again. What a day

kl25 (2/21/2013)

---

Here's the general approach I use:

1. Set a variable for the path (folder). Learned early on to separate the path because paths that I thought would NEVER...

kl25 (2/21/2013)

---

Debbie Edwards (2/21/2013)

---

Heres a thought.....

In the Flat file connection managers properties I have

ConnectionString set to \\D-fs07\spar-it\PROJECTS\1 Active Projects\DATA WAREHOUSING PROJECT\Development\Extract_To_CSV\Test.csv

And Expressions Connection String set to @[Extract_To_CSV_Folder]+@[User::DFES_NAME_DATE_File_Name]+".csv"

The fact...

Debbie Edwards (2/21/2013)

---

:doze: your right! I think Im going to have to reask for a bigger screen, I dont think my eye sight is doing me any favours. Ill have...

:doze: your right! I think Im going to have to reask for a bigger screen, I dont think my eye sight is doing me any favours. Ill have another go...

Heres a thought.....

In the Flat file connection managers properties I have

ConnectionString set to \\D-fs07\spar-it\PROJECTS\1 Active Projects\DATA WAREHOUSING PROJECT\Development\Extract_To_CSV\Test.csv

And Expressions Connection String set to @[Extract_To_CSV_Folder]+@[User::DFES_NAME_DATE_File_Name]+".csv"

The fact there are 2...

Its very strange. Its gone to about 3 different places. Almost like the last folder I was looking at when I was working on a different project.

I realised I...

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...

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...

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

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...

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...