dtsx

SSIS: How to progmatically direct work flow in dtsx package

I have a SSIS package, which depending on a boolean variable, should either go to a Script Task or an Email task.(Note: the paths are coming from a Script Task) I recall in the old dts designer there was a way to do this via code. What is the proper way to accomplish this in SSIS? ...

SSIS (DTSX) Execute package failing on production server.

So I have created a SSIS package and it works great on my dev machine. But, when I try to run it on the production server, it errors our on me. Here is there error: Error: The AcquireConection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. I have figured out the cause, but am ...

Passing a variable to dtsx package results in unexpected precedence constraint evaluation

I have a dtsx package with a precedence constraint that evaluates an expression and a constraint. The constraint is "success" and the expression is "@myVariable" == 3. myVariable is an int32, and when set in Visual Studio's design GUI the package executes fine. There are two other paths that check for the value to be 1 or 2. However ...

Problems moving an SSIS .dtsx package

I've created a dtsx package with Sql Server Business Intelligence Design studio, and I am executing it using the dtexec utility. Via dtexec I am setting certain properties at runtime using the /set switch. So my command looks something like: dtexec /f "mypackage.dtsx" /set \Package.Connections[Destination].Properties[UserName];myUserNam...

SSIS and MySql

I have an SSIS package that connects to a mysql server and attempts to pulls data from different tables and inserts the rows into a SQL Server 2005 database. One issue i notice is that at any given time it runs, regardless of what step it is on, it almost always fails to bring in the total records from mysql into sql server. there are ...

where are DTS packages stored in SQL Server 2005?

I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server? ...

DTS Packages Failing in SQL Server 2005

I am getting the following error when my DTS package is scheduled: Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER I am not sure how to get my DTS packages to execute. They run fine when I manually execute them I am running SQL Server 2005. DTS Packages were created using the Import/Export Wizard. ...

DTSX package to upload a table from Access Database to SQL Server

The Problem: I recive monthly data updates for a SQL databse shipped to me in an ACCESS database, there are about 30 tables that follow this pattern the largest table contains ~40k rows. CREATE TABLE [dbo].[TABLE_NAME_HERE] ( [title] nvarchar (255) NULL, [classification1] nvarchar (255) NULL, [classification2] nvarchar (255) NULL, [...

Convert VS2005 dtsx project from to VS2008

I have a numnber of dtsx projects created under VS2005. When I try to convert the solution to 2008 it converts fine but then the .dtproj file can't be loaded: myProj.dtproj' cannot be opened because its project type (.dtproj) is not supported by this version of the application. I have SQLServer2005 installed but I got rid of VS2005 as...

Can I run/test/create dtsx packages outside Visual Studio?

Not too familiar with dtsx packages - can they be created/run outisde Visual Studio? Is BIDS (Business Intelligence Development Studio) just required to do all the above (in Visual Studio) or is it an independent development enviroment for dtsx packages? Please shed some light if you can (and get some eazy rep)! ...

Can't connect to Oracle in dtsx job

When MS-SQL Server 2000 dtsx job tries to run, gets error "Ora-12154 TNS could not resolve service name" Tnsping to the oracle service to connect replies OK The Windows 2003 x64 Server that runs the dtsx jobs has 32 bit Oracle Server, ODAC 32 bit and Oracle Client 32 bit installed. Thank you for your concern , Kayhan YÜKSEL ...

DTEXEC /ConfigFile does not appear to be working

I am creating a dtsx package that I am running through a bat file. At design time, I created a package configuration that points to a specific location. When I am running the package at run-time, however, I am setting the ConfigFile to a package configuration in a different location. It appears, however, that the package is still running...

DTSX files - How to peruse & edit

I have a DTSX file in a project I'm taking over. I have Visual Studio 2005 Pro, but it just opens it as an XML file. SQL Server Management Studio 2005 does the same. I've seen people opening these files in some workflow-esque format; Business Intelligence Development Studio comes to mind. Is this part of Visual Studio or SQL? Does it...

Extract a value from a dtsx file with Powershell

Sql Server Integration Services packages are stored as xml files with a dtsx extension. I need to be able to extract their build numbers with Powershell. The relevant part at the top of the file looks like- <?xml version="1.0"?> <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:ExecutableType="MSDTS.Package.1"> <DTS:Prop...

SSIS - Wizard vs manual vs programming

I'd like to move 26 tables from one DB to another. I see I can do this in the SSIS Import and Export Wizard. I believe the other approach would be to select tools from the toolbar in Data Flow and then configure them all. When is it better to use the wizard and when is it best to create the package manually (with the visual tools) or ...

How to parameterize database connection string in ssis package

Hi all, I have a SSIS package built in Business Intellegience Development Studio which have both source and destination database specified. Now I want to use some variables to parameterize the database connections and run the package in a command line. I try to replace the database name and sql server instance with my variable @[User::...

dtsx execution from VB.net Windows app

Is it possible to execute a SQL dtsx package from a Windows 2005 VB app? If so, can someone show me how or send me a link? I followed the instructions at: http://www.bigresource.com/Tracker/Track-ms_sql-xAKCmQKI/ but the package result was failure. Could this be because the dtsx was not on the local machine? The package works aok by it...

Subversion lock-modify-unlock solution for SSIS .dtsx

Hello! I wonder how i could set up a developer enviroment for SSIS,.dtsx packages in Subversion? I read about Subversion "svn:needs-lock" property and the ability to set auto-props in a subversion repository by setting "enable-auto-props = yes" in the repository config file. The "svn:needs-lock" property is neccesary when working with...

DTSX file limitation

Hi, I'm currently searching for physical size limitation of a DTSX file. We lose someting proporties, and is seems that it's only appening to quite big DTSX file (+5Mb) Does anyone have a good link or advise ? Regards ...

Tool for generating flat files from SQL objects dynamically

Hello! I'm looking for a tool or component that generates flat files given a SQL Server's query result (from a stored procedure or a SELECT * over a table or view). This will be a batch process which runs every day, and every day a new file is created. I could use SQL Server Integration Services (DTS), but I have a mandatory requiremen...