scheduled import/export

I used import/export in SQL 2000 to transfer one table from A server to B
server and save the package and schedule it. This works fine in SQL 2000.
However, when I try to do the same thing in SQL 2005 and after I save the
package, there is no way to schedule it. And I couldn't locate the package I
created in import/export. Does anyone know where I can find the package and
schedule it after the import/export? Is this very different way from
SQL2000? Please help. Thanks.
Hi
"00kobebrian" wrote:

> I used import/export in SQL 2000 to transfer one table from A server to B
> server and save the package and schedule it. This works fine in SQL 2000.
> However, when I try to do the same thing in SQL 2005 and after I save the
> package, there is no way to schedule it. And I couldn't locate the package I
> created in import/export. Does anyone know where I can find the package and
> schedule it after the import/export? Is this very different way from
> SQL2000? Please help. Thanks.
If you saved the task as a SSIS package on the server then you will need to
connect to Integration services to find and run the package.
To schedule a job to run the package copy the command line from the run
package dialog and use this as the parameters for DTEXEC.
>
John
|||Sorry. Do you mean copy the content in "command line" tab in "execute
package utility"? and where is DTEXEC? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John

scheduled import/export

I used import/export in SQL 2000 to transfer one table from A server to B
server and save the package and schedule it. This works fine in SQL 2000.
However, when I try to do the same thing in SQL 2005 and after I save the
package, there is no way to schedule it. And I couldn't locate the package I
created in import/export. Does anyone know where I can find the package and
schedule it after the import/export? Is this very different way from
SQL2000? Please help. Thanks.Hi
"00kobebrian" wrote:

> I used import/export in SQL 2000 to transfer one table from A server to B
> server and save the package and schedule it. This works fine in SQL 2000.
> However, when I try to do the same thing in SQL 2005 and after I save the
> package, there is no way to schedule it. And I couldn't locate the package
I
> created in import/export. Does anyone know where I can find the package an
d
> schedule it after the import/export? Is this very different way from
> SQL2000? Please help. Thanks.
If you saved the task as a SSIS package on the server then you will need to
connect to Integration services to find and run the package.
To schedule a job to run the package copy the command line from the run
package dialog and use this as the parameters for DTEXEC.
>
John|||How can I connect to integration services? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John|||Hi
On Feb 5, 2:31 am, "00EricClapton" <E...@.yahoo.com> wrote:
> How can I connect to integration services? Thanks.
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
>
If you open up object explorere (F8) then there is a large connect
button at the top of the pane. Alternatively you can use the file/
connect object explorer menu options. Choose integration services for
the service type and enter the authentication details.
HTH
John|||Sorry. Do you mean copy the content in "command line" tab in "execute
package utility"? and where is DTEXEC? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John

scheduled import/export

I used import/export in SQL 2000 to transfer one table from A server to B
server and save the package and schedule it. This works fine in SQL 2000.
However, when I try to do the same thing in SQL 2005 and after I save the
package, there is no way to schedule it. And I couldn't locate the package I
created in import/export. Does anyone know where I can find the package and
schedule it after the import/export? Is this very different way from
SQL2000? Please help. Thanks.Hi
"00kobebrian" wrote:
> I used import/export in SQL 2000 to transfer one table from A server to B
> server and save the package and schedule it. This works fine in SQL 2000.
> However, when I try to do the same thing in SQL 2005 and after I save the
> package, there is no way to schedule it. And I couldn't locate the package I
> created in import/export. Does anyone know where I can find the package and
> schedule it after the import/export? Is this very different way from
> SQL2000? Please help. Thanks.
If you saved the task as a SSIS package on the server then you will need to
connect to Integration services to find and run the package.
To schedule a job to run the package copy the command line from the run
package dialog and use this as the parameters for DTEXEC.
>
John|||How can I connect to integration services? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>> I used import/export in SQL 2000 to transfer one table from A server to B
>> server and save the package and schedule it. This works fine in SQL 2000.
>> However, when I try to do the same thing in SQL 2005 and after I save the
>> package, there is no way to schedule it. And I couldn't locate the
>> package I
>> created in import/export. Does anyone know where I can find the package
>> and
>> schedule it after the import/export? Is this very different way from
>> SQL2000? Please help. Thanks.
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John|||Hi
On Feb 5, 2:31 am, "00EricClapton" <E...@.yahoo.com> wrote:
> How can I connect to integration services? Thanks.
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
>
If you open up object explorere (F8) then there is a large connect
button at the top of the pane. Alternatively you can use the file/
connect object explorer menu options. Choose integration services for
the service type and enter the authentication details.
HTH
John|||Sorry. Do you mean copy the content in "command line" tab in "execute
package utility"? and where is DTEXEC? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>> I used import/export in SQL 2000 to transfer one table from A server to B
>> server and save the package and schedule it. This works fine in SQL 2000.
>> However, when I try to do the same thing in SQL 2005 and after I save the
>> package, there is no way to schedule it. And I couldn't locate the
>> package I
>> created in import/export. Does anyone know where I can find the package
>> and
>> schedule it after the import/export? Is this very different way from
>> SQL2000? Please help. Thanks.
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John

Schedule to export the data to csv file

Hi,
I'm new to SQL. Recently I need to setup a schedule job to export data into
csv file every month. I know I can do the schedule part, but I need help
with writing exporting data script.
select * from tb1 to file info.csv
Thanks in advance,
SarahCreate a data transformation services package and schedule it. See DTS in BO
L
for more info.
AMB
"SG" wrote:

> Hi,
> I'm new to SQL. Recently I need to setup a schedule job to export data int
o
> csv file every month. I know I can do the schedule part, but I need help
> with writing exporting data script.
> select * from tb1 to file info.csv
> Thanks in advance,
> Sarah
>
>|||You can do this a couple of ways. The easiest would be to create a DTS
package with the source as your SQL database & the destination as the file.
You can make it a job & schedule it to run at defined intervals. An
alternative is to use oSQL & define the destination. Again you can schedule
it to run it whenever you want. Details about DTS as well as OSQL.exe can be
found in SQL Server Books Online.
Anith|||Thanks Anith and Alejandro for your quick response. I didn't explain my
question properly. I like to gather data from a few tables and export it.
Would I be able to do this as well? I know how to export one table using
DTS, but not from several tables.
Thanks,
sarah
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:4BCB9529-FD4F-4DFC-98F9-A09A8994EC6F@.microsoft.com...
> Create a data transformation services package and schedule it. See DTS in
> BOL
> for more info.
>
> AMB
> "SG" wrote:
>|||>> I know how to export one table using DTS, but not from several tables.
You can do the same with the resultset of a query which involves multiple
tables.
Anith|||Hi Anith,
I'm new to SQL. I don't quite sure how to do the same with resultset of a
query. Would some sql scirpt be involved?
Would you mind giving me more information about it?
Appreciate it.
Sarah
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:evi1NBcSFHA.3516@.TK2MSFTNGP10.phx.gbl...
> You can do the same with the resultset of a query which involves multiple
> tables.
> --
> Anith
>|||>> Would you mind giving me more information about it?
Sure, but did you get a chance to check SQL Server Books Online regarding
how to use DTS? If you haven't, please do.
DTS Import/Export wizard is a simple, easy-to-use interface which among
other functionalities, allows you to transform & transfer data to external
destinations in pre-defined formats like CSV, tab-delimited etc. There are
provisions in DTS wizard to write SQL queries & specify the output formats
which can be used in your case. Also, for commonly found issues, there is an
excellent website: www.sqldts.com
For reference:
http://msdn.microsoft.com/library/e...ls_wiz_8vsj.asp
http://www.sqldts.com/default.aspx?276
Anith

Schedule job, SP and DTS transaction problem

Hi all,
I have a DTS to export a CSV and a SP to call the DTS and schedule the SP to
execute.
My problem is that the DTS have been blocked by the schedule job.
Here are those program:
DTS sql:
exec sp_GetResultForExportCSV
SP:
CREATE PROCEDURE sp_DayEnd
AS
-- insert ...
-- update ...
-- call DTS
EXEC('master.dbo.xp_cmdShell ''DTSRun /~Z0xE6FEF651097....'',
no_output')
Return
Schedule sql:
Begin tran
exec sp_DayEnd
commit tran
If i remove the begin tran, the schedule run successfully. But is it not
possible to have begin tran?
And I have tried the transaction setting of the DTS properties(transaction
on/off, read uncommitted, etc...), all doesn't work with 'Begin tran'. The
DTS always block when running the DTS sql (exec sp_GetResultForExportCSV). I
think the SP and xp_cmdShell DTSRun is not executed within the same
transaction, is it the limitation?
Thanks in advance!
MartinHi,
why you do the Begin and Commit in Schedule sql? not in sp_DayEnd.
I guess since the insert and update have not been commited yet and they
are requiring exclusive lock on the reords, in the same SP, you are trying t
o
export data from the tables that are being locked. That may be the reason
why the master..xp_cmdshell is waiting for the lock to be relase which
actually will never happen. I suggest you to put the following in sp_dayEnd
Begin Tran
Insert...
Update...
Commit Tran
Exec 'master..xp_cmdshell xxxxxxxxxxxxxxxxxxxxxxxx'
HTH
Ed
"Atenza" wrote:

> Hi all,
> I have a DTS to export a CSV and a SP to call the DTS and schedule the SP
to
> execute.
> My problem is that the DTS have been blocked by the schedule job.
> Here are those program:
> DTS sql:
> exec sp_GetResultForExportCSV
>
> SP:
> CREATE PROCEDURE sp_DayEnd
> AS
> -- insert ...
> -- update ...
> -- call DTS
> EXEC('master.dbo.xp_cmdShell ''DTSRun /~Z0xE6FEF651097....'',
> no_output')
> Return
>
> Schedule sql:
> Begin tran
> exec sp_DayEnd
> commit tran
>
> If i remove the begin tran, the schedule run successfully. But is it not
> possible to have begin tran?
> And I have tried the transaction setting of the DTS properties(transaction
> on/off, read uncommitted, etc...), all doesn't work with 'Begin tran'. The
> DTS always block when running the DTS sql (exec sp_GetResultForExportCSV).
I
> think the SP and xp_cmdShell DTSRun is not executed within the same
> transaction, is it the limitation?
> Thanks in advance!
> Martin
>
>

schedule export of report

What is the syntax (or process) to schedule a reporting services report to be
exported as and Excel spreadsheet and then emailed to recepients?
Are there any examples that I could refer to?
I would like to write some kind of script and schedule this for every day.its the UNC mapping, you dont use the drive letter. Example:
\\server\folder1\folder2\folder3\application
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:9E9BAAB5-CD24-4CCC-A892-A424BBCA498F@.microsoft.com...
> What is the syntax (or process) to schedule a reporting services report to
> be
> exported as and Excel spreadsheet and then emailed to recepients?
> Are there any examples that I could refer to?
> I would like to write some kind of script and schedule this for every day.|||nevermind, I misread your post
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:9E9BAAB5-CD24-4CCC-A892-A424BBCA498F@.microsoft.com...
> What is the syntax (or process) to schedule a reporting services report to
> be
> exported as and Excel spreadsheet and then emailed to recepients?
> Are there any examples that I could refer to?
> I would like to write some kind of script and schedule this for every day.

Schedule export from sql database to access

Hi
Can someone explain/help how can I create a schedule at SQL Server 2000 that
exports at X time of the day a SQL database into a access database without
exporting the views that the SQL database has.
Thanks
[]
Ricky
Take a look at the Import/Export wizard and sql agent in BooksOnLine.
Andrew J. Kelly SQL MVP
"Ricky" <newsgroupsmail@.gmail.com> wrote in message
news:OTItwJhVHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi
> Can someone explain/help how can I create a schedule at SQL Server 2000
> that
> exports at X time of the day a SQL database into a access database without
> exporting the views that the SQL database has.
>
> Thanks
> []
> Ricky
>
>

Schedule export from sql database to access

Hi
Can someone explain/help how can I create a schedule at SQL Server 2000 that
exports at X time of the day a SQL database into a access database without
exporting the views that the SQL database has.
Thanks
[]
RickyTake a look at the Import/Export wizard and sql agent in BooksOnLine.
Andrew J. Kelly SQL MVP
"Ricky" <newsgroupsmail@.gmail.com> wrote in message
news:OTItwJhVHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi
> Can someone explain/help how can I create a schedule at SQL Server 2000
> that
> exports at X time of the day a SQL database into a access database without
> exporting the views that the SQL database has.
>
> Thanks
> []
> Ricky
>
>

Schedule export from sql database to access

Hi
Can someone explain/help how can I create a schedule at SQL Server 2000 that
exports at X time of the day a SQL database into a access database without
exporting the views that the SQL database has.
Thanks
[]
RickyTake a look at the Import/Export wizard and sql agent in BooksOnLine.
--
Andrew J. Kelly SQL MVP
"Ricky" <newsgroupsmail@.gmail.com> wrote in message
news:OTItwJhVHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi
> Can someone explain/help how can I create a schedule at SQL Server 2000
> that
> exports at X time of the day a SQL database into a access database without
> exporting the views that the SQL database has.
>
> Thanks
> []
> Ricky
>
>

Schedule DTS Package

I have MS SQL installed on my workstation at work. I am trying to use DTS to export data from our local network that uses a Pervasive DB to our web server that is hosted with another company.

If I go in and manually execute the DTS package from my workstation, it send the data to the web server.

If I try to schedule the DTS Package to automatically send the data, it fails. SQL Server Agent is running on my workstation and on the web server.

Is what I am trying to do possible? What am I doing wrong?This is a very frequent problem and it is related to permissions.

This is a KB article that describes the problem and the solution:INF: How to Run a DTS Package as a Scheduled Job

Terri

schedule a ssis job

I created a ssis package on my local developer sql server, the package is to connect to another sql server, and export a view to an excel file and send an email with excel attachment.

If I run the package manually it works great.

But now I want to schedule it to run as a job in my local sql server, I cannot make it right.

What I did is:

Create my credential to map to my windows log in
Then create a proxy account to map credential.
Then run the job using my proxy account, but I keep getting errors, . The package execution failed. The step failed.

I cannot get more detailed info.

Please advise.

ThanksThe end of this KB article has instructions for getting detailed info:
http://support.microsoft.com/kb/918760