47. Yes, I used paths, but I can still access those paths from my test box.

Pooh. Ok, what if I go into the production server, connect to Integration Services & when I get to the export step, I export it to my test SQL box...

I have a similar question (I think). I'm attempting to practice upgrading from SQL 2005 to SQL 2008 on my test machine. I've moved over all my db's and log-ins....

Awesome! Yes, both of these help me tremendously! Thank you so much!

I've been wanting to learn about the STUFF syntax, too. I'm going to dive into both of these...

LutzM, I just read your articles on crosstabs. I am sure I'm just being thick-headed, but I cannot wrap my brain around how it applies to my situation because I...

This is the script. The username exists and has permissions. I can run this script on my local install of SSMS remotely connected to the test server. I can run...

I tried using Greg's script and it works perfectly for my needs on my production server, but when I attempt to run it on my test server, I'm getting a...

I'm having the same issue and would like to try...

Todd--You were exactly right!!!! I had not refreshed my data. Once I did, I no longer got the unicode error. I have read both of the blogs you referenced and...

Ok, I probably seem really dense to you, but I've been reading about this unicode-non-unicode issue all morning and now I'm really confused. I am now trying to export just...

Russel Loski (8/29/2010)

---

Does the connection manager for the flat file have the column that you want to leave out? My guess is that by selecting ignore on the mapping...

I click on the flat file destination source and go to the Mappings area and I'm selecting <ignore> on the input column. However, the file that is getting produced still...

Eureka! That worked perfectly!!! Thank you again very much for your help!

Phil--Thank you so much for trying to help me. Can you tell me exactly where I would put the script? Can I just paste it into notepad and give it...

I've determined that all I need to do to make this work is to open up the file and add a comma to the end of the header record. (I...