You've posted in an Integration Services forum. Please will you confirm whether you are referring to DTS packages or SSIS packages?

Thanks

John

As I said before, try it.

You don't use the variables in or after your final CREATE TABLE statement, so it doesn't matter if you kill them.

John

There's only one way to find out! You may need to put an extra GO in before the CREATE USER statement, since I think the latter may have to...

Variables only live as long as the batch in which they are created. GO is a batch separator, and so it has the effect of killing all variables. ...

Please can we see what you've tried so far? Also, DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements would also...

I'm afraid I don't understand what the problem is. Please will you post your code to help me?

Thanks

John

Chances are that only your default instance is listening on the default ports (1433 and 1434). Your named instance will be listening on another port, which is dynamically assigned...

Of course, the results you get will depend on the date on which you execute the INSERT statement. I think you need to lose the [font="Courier New"]OR 1=1[/font], since...

With that level of detail, I can't be more specific than to suggest you use the REPLACE function.

Also, have you considered using SSIS instead of bcp? You may find...

Yes, that's exactly what I had in mind. Try that, and post back if you have any difficulties.

John

LF

The simplest way is to create a table with one column for each variable. SP1 can then write to that table, and the job can pick up the variables...

Please will you post some sample data showing what you have in your source tables, and what you want your target text file to look like.

Thanks

John

In your original post, you appear to have two tables: "table1" and "table2". In your sample data, you only have one: "Table". If you could post some CREATE...

Warren

My view is that you should back up everything (within reason) and then it's there if you need it. Just because you can't think of a reason why a...

That looks very complicated. To convert milliseconds to seconds, just divide by 1000. To convert microseconds, divide by 1000000. I don't really understand why you need to...