I'm trying to add some secure FTP code to an SSIS package. I've used the EnterpriseDT product successfully on other .NET projects, so I wanted to incorporate it into an SSIS 2008 package I'm working on. If I create a Script Task (VB), edit the script, choose Project | Add Reference, and select the editFTPnetPRO.dll file, it comes back w...
(Flat File Location) Samba Share | Windows Share (SSIS) _______________________________ | | XP 32bit | Works | Works | | 2003 Serv 32bit | Works | Works | | Vista 64bit ...
Hi, I need some feedback on what is the best way to do what I want to do, allow me to situate. I have a huge database which receives new inputs constantly. Now I need to have an excel file which shows all the columns of inputs of the past day. So I thought the best way to do this is to use SSIS packages. I never really used SSIS that m...
How do you validate a date in MySQL ? In SQL Server, we have "ISDATE()" to validate whether the expression is a valid date. What function do we use in MySQL ? ...
I am very new to SSIS, looking at a package already created by someone else and deployed on SQL server. There is a File System Task that moves files to a network share. I need to change the path of the destination folder. The destination folder requires a domain login. I can change the folder path in the global variable. Do I have to...
I was about to import data from a table in MySQL to SQL SErver 2008 through SSIS. But I cant transfer due to Dates in the table. There are some data of datetime data type, like '0001-01-10' which doesnt support in SQL Server where years in date ranges from 1753 to 9999. So how do i solve this in MySQL queries ? ...
how do we move the failed or error data to another table while importing data, in SSIS 2008 ? ...
How to deploy the SSIS package to another server ? What are the steps to be done for deployment in an another server ? ...
I have created an SSIS package to connect to multiple SQL servers, create a database, a table and a stored procedure. The package also creates a job and schedules it to run every 5 minutes. The requirement is to collect performance metrics. I am using an ado object variable to get the server names and all the above tasks are in a for ea...
Hi, i am starting with SSIS now. I have a package created to run SQL script, to export it in flat file and send it with e-mail as attachment. "Send mail Task” is giving me an error as “SMTP server is not specified. Provide a valid name or IP address”. But in connection manager I explicitly put the server name in form aaaaa.mydomain.ca. L...
I am running Visual Studio 2008, the SSIS Tutorial described on: http://msdn.microsoft.com/en-us/library/ms167106.aspx I finished all of the tasks but am getting following errors: Error 1 Validation error. Extract Sample Currency Data: Extract Sample Currency Data: input column "CurrencyAlternateKey" (123) has lineage ID 55 that ...
I have an SQL Server integration Services (SSIS) package using the standard Event Log provider (yes, the event log! I know we can use SQL etc...) The default "Source" of the log events is "SQLISPackage100" but I want it to be something like "AppName" so that the errors are more visible between the different packages when viewing the ev...
How do we redirect error/failed data to another table in SQL Server, during data importing in SSIS 2008 ? ...
Is there any way to develop SSIS packages in SQL 2005 without using BIDS? ...
In SSIS,I had tried to deploy a package, which is for importing data from MySQL to SQL SErver 2008, at another server. When I tried to execute the Package from SQL Server, the deployment failed. The error was access permission denied for MySQL user. What is the solution for this ? should I have to set any permission ? I have installed My...
I am trying to add a standard .NET reference (System.DirectorySearcher) to a VB Script Task in SSIS 2008. I was able to do this in SSIS 2005, but when I try to add the reference in 2008, I get the following error: No template information found. See the application log in Event Viewer for more details. To open Event Viewer, clic...
I will be creating flatfiles and based on the data in the batch, it might be necessary to split the data into an undetermined number of files. I can make the connection string dynamic with an expression, but that is only evaluated when the package starts. I'd like to change that expression to include a '-a' or '-b' in the filename. Al...
I have an SSIS package that imports an excel spreadsheet into an SQL Server 2008 database. I have an Excel connection in the Connection Managers tab and it points to an Excel file on my local computer. But when I open the Excel Source in Data Flow, if I try to view columns or change the "Name of Excel sheet:" I get this error. Error a...
I need to import sheets which look like the following: March Orders ***Empty Row Week Order # Date Cust # 3.1 271356 3/3/10 010572 3.1 280353 3/5/10 022114 3.1 290822 3/5/10 010275 3.1 291436 3/2/10 010155 3.1 291627 3/5/10 011840 The column headers are actually row 3. I can use an Excel Sourch to...
Hi everyone, I have an SSIS package that won't error out even with bad input. In my case this package reads from a flat file and puts records into a SQL Server table. Pretty straightforward, nothing fancy going on here. The flat file is defined as being ragged right, 80 characters per row, maybe 10 columns in total. Problem: sometim...