Help.
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.
Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and the
destination table being the datasheet that you are inserting into.
HTH
John
Showing posts with label sever. Show all posts
Showing posts with label sever. Show all posts
Sunday, March 11, 2012
DTS and Excell
Help.
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and the
destination table being the datasheet that you are inserting into.
HTH
John
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and the
destination table being the datasheet that you are inserting into.
HTH
John
DTS and Excell
Help.
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and th
e
destination table being the datasheet that you are inserting into.
HTH
John
Can someone help me with a DTS? I have a curser that creates a temp
table and then sever select statments from the tmp table. I am tryin to
place each out put from the many select statements in its own excel
worksheet.Hi
"TG" wrote:
> Help.
> Can someone help me with a DTS? I have a curser that creates a temp
> table and then sever select statments from the tmp table. I am tryin to
> place each out put from the many select statements in its own excel
> worksheet.
The way I would probably do this would be for each select statement to
require it's own transformation with the excel file as the datasource and th
e
destination table being the datasheet that you are inserting into.
HTH
John
Sunday, February 26, 2012
DTS
I am transfering data from a production server to a test
sever. I started a transfer with the DTS wizard then I
realized that I had the name spelled wrong in the to part
so I removed that db from the drop down list. Now when I
try to do another transfer I get the following error
message.
Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
it alredy exists.
When I check the test server this file does exist.
What do I need to do to get my transfer to go?
Can I just delete the above mentioned file?
What is the purpose of the data folder?What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?
>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>|||The to part that I was refering to is on the Chose Destination page of the DTS wizard in the database drop down list. In that list it has a new option. After selecting that I typed in the name of the database that I want to create with the data transfer. I am not trying to create the file that gives me the error I assume that this is something that is created by the DTS.
sever. I started a transfer with the DTS wizard then I
realized that I had the name spelled wrong in the to part
so I removed that db from the drop down list. Now when I
try to do another transfer I get the following error
message.
Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
it alredy exists.
When I check the test server this file does exist.
What do I need to do to get my transfer to go?
Can I just delete the above mentioned file?
What is the purpose of the data folder?What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?
>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>|||The to part that I was refering to is on the Chose Destination page of the DTS wizard in the database drop down list. In that list it has a new option. After selecting that I typed in the name of the database that I want to create with the data transfer. I am not trying to create the file that gives me the error I assume that this is something that is created by the DTS.
Subscribe to:
Posts (Atom)