I'm learning SSIS and this seems like an easy task but I'm stuck. I have a CSV file Orders.csv with this data: ProductId,Quantity,CustomerId 1,1,104 2,1,105 3,2,106 I also have a stored procedure ssis_createorder that takes as input parameters: @productid int @quantity int @customerid int What I want to do is create an SSIS package...
Hi, I would like to ignore the errors that may occur when a batch is commited. In my case, unique columns. The OLE DB Destination Error Output is set to "Ignore failure" but it is still failling. The Data Flow "stop on failure properties" are set to false and the MaximumErrorCount to 0. I don't want to do row redirection to be able to...
Hi, I was developing a SSIS project, but accidentaly, I erased it. However I keep a copy of the SSIS package. So my question is, it is posible recover the project using the package? or is someway to read the package content to start over the project? Thanks ...
In SSIS how do I, 1) Pass a variable to the dtsx package. 2) How to use that variable to control branching to a particular data flow task. Thanks ...
I'm new to SSIS, my project is still in the early stages, with only dev & test environments on separate servers. The production environment will be on the same server as test (I don't have a say in that!). I have a number of packages that each have an SQL Agent job to schedule them and I need a way to handle package configurations for de...
Hi, I like to upload multiple files, with different names, in a single FTP task to server in SSIS package. I am only able to upload one file. the file names are also different e.g xyz, zbc, ced is there any way to upload multiple file in a FTP task in SSIS. Thanks ...
Hi, I have a FTP task in my SSIS package which deletes files from FTP location. But the issue is that if the file(s) or directory is not available on the server, the task gets failed. Is there any way that I can fix this issue? Thanks looking forward for urgent reply. ...
Goal: I have a Db source. Depending on a variable, i need to store it into a fixed width file OR a delimited file. How do I do this in a data flow? I tried creating a conditional split, with two conditions. One condition going to a fixed width destination, and one to a delimited condition. Problem is that conditional split executed BOTH...
Hello! I've got a WMI Event Watcher in my SSIS package which successfully watches a folder for a file. (i.e. in debug mode, it turns green when I copy the file into the watched folder.) I've added a a data flow task to import this (excel) file into a SQL database. Trouble is the data flow task never fires. So, (a) am I using the cor...
I have been trying lately to create SSIS packages from .NET code rather than using drag and drop in Visual Studio. As part of the package documentation, I would like to be able to annotate data flow paths. The code below - copied from MSDN - establishes a path between two SSIS data flow components. By adding path.Name = "My name"; ...
I have an SSIS (super)package that consists of several (about) 40 packages, each of which has several data flow tasks, most of them loading some excel data to a sqlserver database. So I have several excel source connection managers, one per excel file. This has always worked fine until recently : I have to change an excel source in one ...
I don't get the Business Intelligence Project type at all when I try to create a new project and I have looked for two days for a workaround. Is it just not possible to do this in VS2008? ...
Hi, please see the figure to get idea of the scenario. Now when my Package will run after executing the s! task, either A or B path will be followed. So If A is followed then Task S2 and F2 is executed. But if path B is followed, task F1 and F3 is executed. But also after completing task F3, the flow should go to task S2 via path E. ...
One question though lets say publisher database had 100 tables and I use Transactional Replication to move the data from those 100 tables to Subscriber Database that would be fine. But lets say I don't want the 100 tables but i want to create 3-4 Views which contain the key information I want from those 100 tables. How Would I achieve t...
I have transformed an XML file See this question for a complete description What I want to do know is take this xml task and have it preformed in a For Each Loop. I want all xml files in a specific directory to be transformed and the resulting file to be moved to seperate directory. It's not working. I'm getting the following error m...
I assume that by intelligent design the source adapter is parameterized but just wanted confirmation from an SSIS veteran. As an example if I have a source query in the adapter like: select files ,transactions ,dateofsomething from reallygoodtablename where theparameter = ? Does this get prepared by sql and get a cached plan or do...
Hi All, We are currently having an OLTP sql server 2005 database for our project. We are planning to build a separate reporting database(de-normalized) so that we can take the load off from our OLTP DB. I'm not quite sure which is the best approach to sync these databases. We are not looking for a real-time system though. Is SSIS a good...
I'm trying to create a WsHttpBinding entirely in code, within an SSIS Script Task. The script task will not have access to an app.config file at run time so I need to create the binding manually and set the parameters in code: WSHttpBinding binding = new WSHttpBinding{ Security = new WSHttpSecurity{ ...
Hello there I have started working with SSIS recently and I am hit a dead end with the look up transformation error rows redirect to a file. I have configured to send the rows that do not have a match to a flat file destination. But the file will not contain the collumn data, which is blank however the error code and error collumn into ...
I have a dataflow, where there is a DB source and a flat text file destination(delimited by pipe '|'). The DB source is picking up the SQL query from a variable. Problem is that if my DB field size of say, firstname and lastname are 30 characters, i get the output as(space represented by dots) saurabh......................|kumar.........