Hi I have the c:\Program Files\Myexe.exe on the Server1 I run BIDS package on MyPC1 and can't start it. On the server in the task manager I see the process started, but it hangs, possibly because of the security warning. Thank you, Nikolz ...
Hi All, I have a XL source file, the first column contains the name, 199001,19902.....,199012, In SSIS package using XL source if click the 1st column contains headings it automatically covert my heading as name,F2,F3.....F13. But i need as it is like Name,199001,19902,.....,199012 as a heading than i am using unpivot transformation ...
Is there a way to get SSIS (<cough>hateit</cough>) to suggest the types on a flat file connection mgr from a destination table? So the problem is I have a largish table with lots of text fields and even when using suggest types, it will sometimes set the length of those fields smaller than the target column. That, of course, would be f...
I am creating a select statement on the fly because the column names and table name can change, but they all need to go into the same data destination. There are other commonalities that make this viable, if I need to later I will go into them. So, what it comes down to is this: I am creating the select statement with 16 columns, there w...
We've got an architecture where we intend to use SSIS as a data-loading engine for incoming batches. The intent is to reduce the need for manual intervention & configuration and automate the function as much as possible so we're looking at setting up our "batch monitoring" package to run as scheduled SQL Server Agent jobs. Is it possi...
We have an architecture where we use SSIS to extract data from XML batch files into a staging database for validation, prior to exporting it into production. We control the XML format to some extent, and I've been asked to determine what the maximum number of records the XML batch file should contain. Based on the XML schema and some s...
If I have the option of using .Net and can do data transformations just fine in .Net, when would I need SSIS? Is there a certain task that SSIS would be better for? Are the added benefits of transparency worth it? Is it just what I am more comfortable with? What are the best practices for determining this? ...
I have a data flow task that extracts data from one database and inserts into a SQL Server database. After each record is inserted in the master row I also need to insert rows into a detail table. The data for the detail table is pretty simple and can be calculated. How do I retrieve the value of the identity column after inserting? Ho...
I am using a stored procedure to populate a Lookup Transformation, but would like to restrict the size of the lookup cache. I could do this by supplying a parameter to the stored procedure, but I can't see any way of parameterising the query on the Lookup Transformation componenent. Any ideas would be welcome! ...
I have a Data flow task which looks in a table and then uses a row count to save the number of rows into a variable. This variable is used later to decide whether to perform an action. My problem is that when I run this data flow I get a warning because the single column on the output is not used later in the Data flow. I have tried rem...
Can anybody tell me if there is any way to write an expression in variable in SSIS package having more than 4000 characters which is the maximum limit allowed. ...
In an SSIS package, I have a For Loop Container task with the EvalExpression set to true (so that it runs forever). If any tasks inside the For Loop Container fail, then the package must fail -- except for the Execute Package task (that calls a child package). If that fails, then the parent package should move onto the next task. I trie...
I have a SSIS master package, which executes several child packages. It works great, but when I deploy it to the file system on the server, I get an error code "0xC00220DE". "The system cannot find the file specified." When I run the package on the server by double-clicking it, it works correctly. But when I use DTExec: dtexec /FILE "d...
I'm working on an SSIS package where I'm importing data from a CSV file into a SQL table. The only field that I'm concern with is the Username. This Username must be unique. I don't care whether first name or last name are the same or not. In the package, I imported the data from file into a temp SQL table. And then I used SELECT DISTI...
When developing a Data Flow I don't always want to output the results to a destination - but I would like to see the data. Is there a way to attach a Data viewer to an output without having to have a destination? The file and raw destination have limitations on the data type they accept - and I don't want to attach conversions just to ...
I have number of files in .gdb format, which I believe is associated with Borland interbase. Does anyone know how I would go about extracting data from the using SSIS (2005 or 2008)? Any help very much appreciated. Ed. ...
So I am trying to do a bulk insert with SSIS and continually get: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "String or binary data would be truncated." Even though I already have a data conversion for every column into the exact same type as the table that the rows are getting inserted into. I used a view and the...
I have defined a variable as: DateSecondsOffset Int default as 1 in a SQL Server Integration Service project. I use it as constant. In a task, I have the following SQL to set another var NextDT: SELECT dateadd(s, max(timestamp), 1) DT from myTable I would like to replace the 1 with DateSecondOffset so that I can change it whe...
I need to restore a DB from a .BAK-file that is not located on the server, but on my local machine. Normally I remote desktop to the SQL server, copy the .BAK-file, and do the restore that way with Management Studio. This feels a bit awkward though, especially on days like this, when I get thrown out because the number of allowed connec...
I developed ssis project on my local machine, extracting data from mysql db to sql server 2008. Everything works fine. Now i move the package, the .dtsx file, to the server which is a 64bit window 2008 box, it stops working. The problem is that package default to sqlserver driver instead of mysql drive. I have to move the whole project t...