|
|
|
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 |
Filter by week: 1 2 3 4 5 how to pass params to execute SQL task Posted by Awi Ktir at 1/19/2007 12:48:23 PM I have a package that has config file.
there is a variable in the package that should come from the config file and
be fed to a simple update stmt.
the connection is ADO (not ADO.net).
variable is user::mg_id
the config file has the name or the variable and the value in it.
the package has ...more >>
Want to avoid using cursor Posted by Kayda at 1/18/2007 9:23:01 PM Hello:
Currently I have a large SQL Server 2000 DTS package that does many
things--I was able to do everything except one without using cursors. I
want to get rid of the one instance I use the cursor however as it
holds things up.
This is a database that measures events in the life of a pho...more >>
How do you deploy a SSIS package? Posted by newsposter NO[at]SPAM orion-forever.com at 1/18/2007 11:23:17 AM I know this is a basic question, but I'm looking for a simple set of
instructions on how to deploy a local package to a server. I've looked
at the document and struggled with this simple task.
I'm on SQL 2005 SP1 Standard Edition at the moment.
...more >>
scheduling a t-sql stored procedures name in table column without creating a job for each one?? Posted by jobs at 1/17/2007 1:20:40 PM I have an ssis script task written in vb.net that will connect to a sql
server database via ado.net and can execute sql commands.
A control table will hold a list of stored procedures and an action
column that will indicate an sp is ready to run.
what sql command can I use to schedule an...more >>
Users permission to run DTS without being sysadmin Posted by Berimu at 1/17/2007 4:31:37 AM We would like users to run DTS packages in a production without them
being sysadmin or owner of the package? Is this possible using
securitysettings and not a VB, .net interface?
Ivo
...more >>
DTS package remotely Posted by tiv at 1/16/2007 2:37:17 PM I'm executing a dts package on a remote server from a local machine
with the dtsrun cmd. I have all the same ODBC connections on the local
computer that the server has, registered the appropriate .dlls on the
local box. The batch file is getting to the package and kicking it
off. For some rea...more >>
Convert interbase to sql server Posted by alvin at 1/16/2007 12:47:12 PM Is there a utility for me to convert the interbase database 5.6
(data,schema,procedure,trigger,generator,table...etc) to microsoft sql
server 2005? I am manage to find the database (table,table schema)convertion
but not valid for procedure, trigger, generator convertion.
Thank You.
From ...more >>
DTS error--Microsoft Data Transformation Services (DTS) Data Pump Posted by mecn at 1/16/2007 10:55:12 AM hi,
I saved a working dts package to a rest box and run it with the following
error,
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:DataDrivenQuery: One or more destination parameter
columns had no transform specified.
Step Error code: 8...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Slower performance in ActiveXscript task Posted by yinthomas NO[at]SPAM gmail.com at 1/16/2007 3:31:11 AM I implement an ActiveXscript task in a DTS package for looping several
store procedures in SQL 2000. The task run normally (around half an
hour) in the past half an year. However, without any changes of the
DTS, the processing time of this task increased significantly to one
hour. After 2 days, ...more >>
How to get column headings on a job in DTS Posted by Blasting Cap at 1/15/2007 11:56:53 AM I have a crosstab query that I have set up to return a variable number
of divisions (channels) in any given month.
Since my intention is to set up a job to throw the results of this
crosstab query into an Excel sheet & mail it, I need to have matching
headers for the columns. However, they...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |