|
|
You're in the
sql server dts
group:Run DTS without SQL Server
sql server dts:
REM7600 [quoted text, click to view] > You are a man Allan. Thank you. > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
Yes. You will need the DTS dlls though
Redistributing DTS with your program (http://www.sqldts.com/default.aspx?225) -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:ud0RVr2zDHA.1524@TK2MSFTNGP10.phx.gbl... > Hello. > I have a client who connects to our network and I want the client to be > able run DTS package without SQL Server on his computer. > Is it possible ? > Happy New Year to everyone. > >
Hey Allan,
How 'bout some help with this one? Runs fine when I run manually from EM. When I schedule the job and assign it the svcSQL account it fails... What has me baffled is that it processes the datapumptask_1 a little bit(looks like 5000ish rows) and then fails. I could understand if it just failed to process, but why the partial processing? Thanks for any help you might provide! Travis Error from Jobs below... Executed as user: DOMAIN\svcSQL. ...OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed o... Process Exit Code 1. The step failed. [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:OGLCV%236zDHA.1660@TK2MSFTNGP09.phx.gbl... > Thankyou > > I was going to come back with a witty retort earlier but got called away. > > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.allisonmitchell.com - Expert SQL Server Consultancy. > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "REM7600" <rem7600@hotmail.com> wrote in message > news:exaEK56zDHA.3196@TK2MSFTNGP11.phx.gbl... > > I'll give ya a little more credit Allan... You are Da Man! > > > > REM7600 > > > > > You are a man Allan. Thank you. > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > > > >
DTSRUN /E /S<<name of package server>> /N<<package name>>
Start | Run | DTSRUNUI This will help you build a cmdline string -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:%23pRYyA3zDHA.3216@TK2MSFTNGP11.phx.gbl... > Hi, Allan > Thank you . > Let say I 've got these file on client's computer ( I mean , from SQL Server > 2000 Only section) > > What is a example of code to run DTS package now from his computer. > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:OCeQ$x2zDHA.2240@TK2MSFTNGP10.phx.gbl... > > Yes. You will need the DTS dlls though > > > > Redistributing DTS with your program > > (http://www.sqldts.com/default.aspx?225) > > > > -- > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > www.allisonmitchell.com - Expert SQL Server Consultancy. > > www.SQLDTS.com - The site for all your DTS needs. > > I support PASS - the definitive, global community > > for SQL Server professionals - http://www.sqlpass.org > > > > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > > news:ud0RVr2zDHA.1524@TK2MSFTNGP10.phx.gbl... > > > Hello. > > > I have a client who connects to our network and I want the client to be > > > able run DTS package without SQL Server on his computer. > > > Is it possible ? > > > Happy New Year to everyone. > > > > > > > > > > > >
Hello.
I have a client who connects to our network and I want the client to be able run DTS package without SQL Server on his computer. Is it possible ? Happy New Year to everyone.
Hi, Allan
Thank you . Let say I 've got these file on client's computer ( I mean , from SQL Server 2000 Only section) What is a example of code to run DTS package now from his computer. [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:OCeQ$x2zDHA.2240@TK2MSFTNGP10.phx.gbl... > Yes. You will need the DTS dlls though > > Redistributing DTS with your program > (http://www.sqldts.com/default.aspx?225) > > -- > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.allisonmitchell.com - Expert SQL Server Consultancy. > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:ud0RVr2zDHA.1524@TK2MSFTNGP10.phx.gbl... > > Hello. > > I have a client who connects to our network and I want the client to be > > able run DTS package without SQL Server on his computer. > > Is it possible ? > > Happy New Year to everyone. > > > > > >
You are a man Allan. Thank you.
[quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:uaLJOl3zDHA.1684@TK2MSFTNGP12.phx.gbl... > DTSRUN /E /S<<name of package server>> /N<<package name>> > > Start | Run | DTSRUNUI > > This will help you build a cmdline string > > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.allisonmitchell.com - Expert SQL Server Consultancy. > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:%23pRYyA3zDHA.3216@TK2MSFTNGP11.phx.gbl... > > Hi, Allan > > Thank you . > > Let say I 've got these file on client's computer ( I mean , from SQL > Server > > 2000 Only section) > > > > What is a example of code to run DTS package now from his computer. > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > news:OCeQ$x2zDHA.2240@TK2MSFTNGP10.phx.gbl... > > > Yes. You will need the DTS dlls though > > > > > > Redistributing DTS with your program > > > (http://www.sqldts.com/default.aspx?225) > > > > > > -- > > > -- > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > www.allisonmitchell.com - Expert SQL Server Consultancy. > > > www.SQLDTS.com - The site for all your DTS needs. > > > I support PASS - the definitive, global community > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > > > news:ud0RVr2zDHA.1524@TK2MSFTNGP10.phx.gbl... > > > > Hello. > > > > I have a client who connects to our network and I want the client to > be > > > > able run DTS package without SQL Server on his computer. > > > > Is it possible ? > > > > Happy New Year to everyone. > > > > > > > > > > > > > > > > > > > >
Thankyou
I was going to come back with a witty retort earlier but got called away. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "REM7600" <rem7600@hotmail.com> wrote in message news:exaEK56zDHA.3196@TK2MSFTNGP11.phx.gbl... > I'll give ya a little more credit Allan... You are Da Man! > > REM7600 > > > You are a man Allan. Thank you. > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |