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? ...
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 ...
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 ...
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...
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 ...
I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server? ...
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. ...
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, [...
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...
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)! ...
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 ...
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...
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...
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...
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 ...
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::...
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...
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...
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 ...
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...