|
|
|
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 Executing SSIS package by passing parameters from command line Posted by Sal at 5/21/2007 6:40:01 PM
I want to Execute SSIS package by passing parameters from command line just
like we could use DTSRun command in sql server 2000. Please let me know.
Thanks...more >>
Export Data to Excel Posted by James at 5/21/2007 12:37:01 PM I am new to dts packages.
I need to export data on a daily basis from SQL to Excel and would like to
use dts to accomplish it. The data structure will not be changing.
I have the option of creating a new Excel file each day or appending a new
worksheet into 1 main Excel file. My preference...more >>
SISS vs Biztalk Large data Posted by Selvan at 5/21/2007 11:19:02 AM Geeks,
I am a Biztalk guy, I receive a flatfile of 1GB approximatly everyday and
have to transform another flatfile format with in 30 mins of time. As for as
i know flatfiles are converted to xml in biztalk which results 3 times bigger
than the souce flatfile in biztalk databases. From va...more >>
No dataflow destinations in BI Dev Studio Posted by jdieter at 5/21/2007 9:54:39 AM Since installation on Windows vista, I see no data flow destinations
when the data flow tab is selected on a new integration services
project. I AM running VS as administrator.
Using the ssis wizard produces perfectly good packages with
destinations and all.
any ideas?
...more >>
SSIS Package Configuration Posted by C at 5/21/2007 6:57:01 AM Hi,
I have created an XML Configuration file within the Designer and have added
my database connection details.
How do I get my TSQL Task to use this connection. I have currently set to
use a connection I have created within the connection managers window.
Thanks in Advance.
...more >>
Slow package execution Posted by Fredy (Co) at 5/19/2007 9:51:21 AM hello...
I have a problem with a package in SSIS...
The package executes an Execute SQL task that fill a System.Object variable
with a table resultset.
In the development PC, the package execution takes 10 seconds, from the
beggining until the end
But, in the production server, the sam...more >>
Cannot Instantiate Storage Object... Posted by Philip Warner at 5/19/2007 12:00:00 AM I know this has been here before (but not for several years), but I am
getting this message on *some* data (still investigating). The prior
solution (blobs at end) does not seem to be relevant.
Old replies suggest putting BLOB columns at end. I have done this, but
there are 3 BLOB columns. Mos...more >>
ActiveX script within DTS package - Type Mismatch Error Posted by Red at 5/18/2007 4:14:09 AM Hi,
(Firstly, I have cross posted this to a DTS group as well as a
vbscript group, as Im not sure if this is a DTS issue or script
issue. Apologies if I upset anyone)
I have an ActiveX running within a SQL Server 2000 DTS package, which
I am trying to adapt to create a bunch of excel sprea...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Please recommend SSIS Tutorial books. Posted by Conan Kelly at 5/17/2007 6:40:03 PM Hello all,
What books do you guys recommend as good tutorials for SSIS.
I've gone through the tutorials in BOL, but have yet to create a successful
package. Have given up on the SSIS learning for the time being and gone
back to using DTS packages.
Thanks for any help anyone can provide...more >>
dtsrun problem Posted by pelican at 5/17/2007 12:46:01 PM Hi everyone,
I used this command to run a package: dtsrun /S "local"/N "leitest1"
The job failed. I got this error message:
Executed as user: Main\jih. ...version guid, or a source filename. DTSRun:
Invalid command options Usage: dtsrun /option [value] [/option [value]]
.... O...more >>
Import data from Access to SQL Server Posted by Ava at 5/17/2007 12:18:01 PM Hi, I need to import data from Access table to SQL Server table. When I
choose the Access file I got this message:
Error Source: Microsoft JET Database Engine
Error Description: Cannot start your application. The workgroup information
file is missing or opened exclusively by another user.
...more >>
how to programmatically modify an execute process task Posted by Steven at 5/17/2007 11:06:01 AM i've seen sample code using an activeX script to modify the command line of a
execute process task, but i'm unable to get these to work. i need to change
the argument, not command line, of an execute process task from a script task.
does anybody have some sample code i can look at? i can't se...more >>
increment counter Posted by tykster at 5/17/2007 9:36:01 AM I have a DTS package that takes the results of a SQL query and writes it to a
text file. One of the columns in the text file needs to be a counter (value
on first row is 1, second is 2, etc). Is there a way to do this without
sending the data to a temporary table with a autoincrement identity ...more >>
Scheduling a DTS package on the SQL Agent its hang. Posted by kcThong at 5/17/2007 1:58:01 AM I am using SQL 2000 and executed a DTS package and runs sucessfully on the
designer platform. When I scheduled it to run on the SQL Agent, it hangs. The
package was designed as new on the running server itself and saved with sa
password. What can be the problem ? Can anyone please advise ?
...more >>
Importing DTS via a script Posted by Kayda at 5/16/2007 7:35:23 PM Hi:
I was wondering if I have several DTS files if it is possible to save
them on a SQL Server via a script that references a path to the files.
I would like to know the same for both SQL Server 2000 and SQL Server
2005.
Thanks,
Kayda
...more >>
Automating Query Posted by juliaisabel at 5/16/2007 4:07:17 PM I am I am looking for the best method of automating an INSERT query in SQL
Server 2005
Code:
------------------------------------------------------------------------------
--
'INSERT INTO SaltInvWhOpen (StockCode, Warehouse,
TrnMonth, TrnYear, OpenBalQty, OpenBalCost)...more >>
concatenate in SSIS Posted by Billa at 5/16/2007 12:43:18 PM Hi,
I have following in put
person ID____________Choice
-------------------------------------
1___________________Apple
1___________________Banana
1___________________Peach
2___________________Lemon
2___________________Coconut
and I want to translate in following
person ID___________...more >>
Execute Remote DTS-Package on different Server Posted by w.stefan at 5/16/2007 12:55:38 AM Hello DTS discussion group,
i'm going crazy with one maybe simple problem on executing DTS on
SQLSERVER 2000.
Situation:
I have in my local environment a DTS-Package, which starts another DTS-
Package. I used
both dtsrun as command line task and the exisiting Execute Package
Task from DTS...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |