Might want to start here:

http://msdn.microsoft.com/en-us/library/ms162820(v=sql.105).aspx

can you add a bit more info?

Are you looking to automate the deploys via command line dtutil? Or is this a package config issue? what type of configs are you...

Thanks for all the suggestions and tips this has been very helpful if only to verify that we have already tried it or to give us some new direction.

Lynn Pettis (6/10/2013)

---

Looking at this:

text 16 0 0

text 16 0 0

text 16 0 0

You do realize that the 16 bytes is simply the pointer to the data. What about...

Doing set based deletes, no triggers, and no dependancies of any kind for that table.

If we could have RI with a single dimension set and no performance hit then by all means we would. So I don’t look at from the standpoint of being...

Couple points to add here. First the ETL is the only process that can change this data. Remember this is a data warehouse, one load process and the rest are...

Thanks for the feedback we'll take a look these ideas - Tom

thanks but did you read my post?

We use proxy accounts to run jobs, what I'm looking for is a way to...

thanks for the unicode reminder.... N'Was Scratching my head too'

Ok that makes sense, I figured it was something along those lines but just wasnt sure.

thanks for the reply

I have not done this but if you use the dbtimestamp it should allow implicit conversion between the two. You could also use an ADO connection and try the Time...

yeah sorry about the omission on the linked server....

Thanks for the feedback I'll look into the cert idea.

I think we tried the ownership chaining before but in this case the query is hitting a table over a linked server and the impersonated account is mapped to a...

does each record type have different columns / widths?

is each record type running in different data flows with different formatted output that all need to go into the same file?

If...