I've tried with this for over 48 hours and no luck. I then create a simple package, one FTP task to download text files. I deployed the package using the option "SQL Server Deployment". I see the package in SSIS but when I try to run from command line with the command dtexec /ser svrprod05 /sq Package I get the error Microsoft (R) SQ...
I created Transfer SQL Server Objects Task in the SSIS. It seems to work but Default Value doen't copy properly. Is there any way to copy Default Value using SSIS? ...
I have developed an SSIS custom task component. It uses a connection manager of the ado.net variety to do its database work. I'm in the processes of adding a GUI to the component and I can't find a way to filter/display just ado.net connections. I'm using the following code to load the connections into a list box. //Load up C...
Consider these 2 machines: #1: Full SQL Server 2008 without Team Explorer (test SQL box) #2: Development box with Visual Studio 2008 SP1 with Team Explorer I use Team Foundation Server 2008 and would like to check SSIS projects into source control. Do I need to install BIDS as a separate Visual Studio 2008 shell in my machine #2? I ...
When I do for example DATEPART(mm, GETDATE()) I get the result of the month being "8" for August. If i did the same thing in December I would get "12". Those are two different length results. Is there a way to get the DATEPART results to always be a fixed length? So that for example the months would show up as 08 or 12. And days would b...
In an SSIS package I am using a flat file source with a date column, and some of the dates are empty strings. I want these empty strings to be treated as null when the data from the file is loaded into the database. I have checked the "Retain null values from the source as null values in the data flow" checkbox in the Flat File Source Ed...
I have made an SSIS package that uses the Excel source to extract data from an Excel 2003 file and inserts it into SQL Server. When executed on production machine it gives and error of 'productleveltoolow'. Excel is not installed on the server. Can this error be due to this reason? ...
I am trying to troubleshoot this error without success. I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv file into a table where all of the field types are NVARCHAR MAX. It works on my computer, but it needs to run on the clients server. Whenever they create the same pack...
I am using SQL Server Integration Services 2008 to put a certain boolean value in the database, and originally I used the SSIS type of DT_BOOL (boolean). However, in the database, the boolean value is being stored as a tinyint field (for legacy reasons). A boolean value of TRUE would be saved in the database as 255 (all bits on), inste...
I have an SSIS package that queries data from a view using an SQL Command. The SQL Command looks something like this: SELECT from myView WHERE dateEntered >= GetDate() AND dateEntered < GetDate() + 1 Now I want to be able to specify the start and end dates such that the query behaves as: SELECT from myView WHERE dateEntered >= startD...
I know this isn't a "good" thing to do, but its also a temporary measure on several internal servers used by a select few developers. So please forgive me engaging in "very bad things" :) The crux of the problem can be seen when I open any of my connection managers: the password field is empty. I am using SQL Server Authentication with ...
We have a large collection of DTS packages that need to be converted to SSIS as part of SQL upgrade?. How effective is this tool compared to the wizard?. Some of the functionality that is available in DTS Import/Export SQL operations Copying/Renaming/moving files Activex scripts (Not complex, most of the business functionality is in St...
I am loading tables in my warehouse using SSIS. Since my SSIS is slow, it seemed like a great idea to build indexes on the tables. There are no primary keys (and therefore, foreign keys), indexes (clustered or otherwise), constraints, on this warehouse. In other words, it is 100% efficiency free. We are going to put indexes based on ...
I can see "SQL Server Compact Destination" under Data Flow Destinations, but I am looking for its source counterpart. If I choose ADO.Net source and create a new connection, there's no provider for SQL CE. What am I missing? Thanks! Update: I am able to create a "Data Source" (under "Data Sources" folder in my SSIS project") that con...
Background) I've gone through the process of building a fact table for our inventory data that will in theory act as a nightly snapshot of our warehouse. What is recorded is information such as quantity, weights, locations, statuses, etc. The data is very granular and in many cases not specifically related to a single entity (our source ...
Hi all, I am currently trying to use a web service I developed within an Integration Services package. When I try to configure the web service task I keep getting an error message. I configured the HTTP connection, and successfully downloaded the WSDL file which overrides my local copy. After that, on the input tab, I try to select the ...
I am trying to sync up a SQL Server table with a Lotus Notes database. I have set up the NotesSQL ODBC driver and have been able to insert, update and select from the notes database form using the ActiveX Script Task in DTS. Everything works well until I try to insert Chinese characters into Text field in the notes database. After insert...
I have created a .NET application designed to use the RemoveFromSQLServer function to delete DTS packages from a SQL server. This is the entirety of the code: Sub Main() Dim app As New Application app.RemoveFromSqlServer("dts_rob_temp", "MyServer", Nothing, Nothing) End Sub When I try to run it, I get the below fairly undescri...
Hi , I am using SSIS 2005 for creating package. I am having a requirement where i need to get data from databse store it in adestination and retrieve only email ids from that store nad send mails to each and evry id that i have received. I am using Expressions in the send mail task where i am getting the mail ids from the record set stor...
Anyone know a way to pass an argument to the XSLT when using an SSIS XML Task? There seems to be no obvious way to do this, but there may be some clever workaround/hack? EDIT: I'm currently looking into running an xpath update to insert param values... EDIT: I got this working in the end by using a script task to insert the parameter ...