Recent update: 2008-3-21
I have done this twice now. I am sure I will do it again. I have a date dimension. Among other things the dimension contains columns for a meaningless id and raw date. If I want to translate a date to a the meaningless id for storage in a fact table, I use a look up component. All fine and ...
Hello,I can gain access to and execute my package using the Application and Package objects. I am handling the events of the Package object and can even see the OnPipelineRowsSent event when it fires to deliver the rows to the Datareader destination. How do I gain access to those rows for use ...
I setup my ExecuteSQL task to have a "Single Row" resultset. The query returns no rows. It fails. I don't think it should but then maybe this is consistent with the lookup transform piping rows down the error output if there is not a lookup value returned.The error returned isError: 0xC002F309 ...
Since the last IDW.The column "ParameterName" has been added to the ParameterMapping tab of the ExecuteSQL task.I enter a statement of SELECT * FROM TABLE WHERE COLUMN = ?I map ? to a input variable. The default name of the parameter supplied is "NewParameterName"My task now fails withError: ...
Hello, What can i use to retrieve the physical application path in a dts script task ? with asp.net it is request.PhysicalApplicationPath Thanks a lot
So I've built my own custom task and it has a selection of properties.I drop it onto designer and can see the properties (VS Property Grid not custom UI ).The properties window retracts and I decide to reopen the property window. My Properties have now disappeared (mine - not inherted). Never ...
50 byte By
guest at 2008-2-28
how to transfer sql2000 data to sql2005 using ssis
When i am running the package using dtexec utility on the command prompt i'm getting this error for every connection that is not windows authenticated. however in the debug mode it is always working Source: Connection manager "connection_name" Description: Failed to decrypt protected ...
I'm trying to develop a report using an SSIS DataReaderDestination as the reports data souce. When I attempt to create the report DataSet, SSIS is not an option for the Data Source parameter....Is there an OLE DB or .NET provider for SSIS that I need to install apart from installing reporting ...
I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following.1. When I set up an OLEDB data source for the AS400 (using IBM's Client ...
724 byte By
krog at 2008-2-24
Hi, When I click on the MSDB node, under Stored Packages (in Object Explorer | my local server's Integration Services), I get the following error message: Client unable to establish connection Encryption not supported on SQL Server. (Microsoft SQL Native Client) I can, however successfully, ...
I have two databases with approx 250 tables each. Database 1 is the staging DB and Database 2 is production. I need to append all the rows from staging to production.In SQL Server 2000 I used a Copy Sql Server Objects task, checked all the boxes for the tables I wanted and told it to append the ...
1842 byte By
KDog at 2008-2-22
Hi, * Here's my use case: I have 20 odd event handlers in various containers that all do the exact same thing. Even though they're simple (a Script and an Execute SQL Task), its a right pain to copy them & keep them synced. I could probably create a custom task for the content of each ...
516 byte By
CraigN at 2008-2-22
How do I create a Data Flow Task with an ODBC Data Flow Source? I know how to create an ODBC Connection Manager (at the bottom of the screen). But, when creating the data flow task, what do I use for the source component ... what do I drag from the toolbox under Data Flow Sources? All I have on ...
I don't understand how to pass a parameter to a dts package from another. In SQL 2000 you can map a variable with a variable of the package you will call.How can I do this?For example in the current package execution (package1) I have a variable1 = 5 and when some step complete I call package2 ...
I have just installed the June CTP, during the installation it says that it is installing the Integration Services but they do not seem to be there.I am happy to admit that I am being dim but I cannot connect using the object browser, nothing is listed if I search for services and there is ...
I setup a job which call a dts package (I try to call it from file system and from SSIS Package Store with the same result) and it doesn't run.If you take a look from the SQL Server Agent you could see this >>2012-06-17 09:01:02 - ! [LOG] Step 1 of job 'prueba' ...
262 byte By
GiriT at 2008-2-20
Just for all you June CTPers as a warning.. I have a UNION ALL that, at random, decides to swallow row count.... Tried deleting and recreating task Unable to Repro Along with the buffer leaks and the looping errors.. bring on the NEXT CTP.. ! ! !
Source table has two fields, int and string. Destination has three fields, int, string and Uniqueidentifier (Guid). For each source row added to the destination, I need to add a new Guid. I know how to make a new Guid in VB.NET script, but how do I inject it into the transformation for each ...
Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express?
1088 byte By
sashp at 2008-2-18
Hello all,I'm implementing an application that builds SSIS package. I've faced the problem I don't know what to do about it.In a simple case, I build a dataflow which has OLE DB Source and OLE DB Destination component. The problem is, that at the moment I build the dataflow I don't h...
I'm trying to develop a report using an SSIS DataReaderDestination as the reports data souce. When I attempt to create the report DataSet, SSIS is not an option for the Data Source parameter....Is there an OLE DB or .NET provider for SSIS that I need to install apart from installing reporting ...
605 byte By
Hanan at 2008-2-17
Hello,I am trying to programatically create an SQL Server destination in SSIS. I am creating the connection string, then initiating a connection, and then call AcquireConnections(nothing). When running in debug mode or in command line, all works perfect. However, when running from within a Windows S...
If I have a derived column in the middle of a data flow diagram and I change the derived column's data type, I have to open all of the data flow items beyond it before the change is propagated. In one case I had to remove it from a merge join and re add it before the change was acknowledged. ...
Is there anyway to allow my Data Flow annotations to wrap? (April CTP) Thanks
Has anyone successfully debugged a Script transformation in a Data Flow by setting breakpoints and stepping through the logic of the script? I can't seem to get the breakpoints to stop execution. Any assistance would be appreciated.
I have a .NET component that I want to import into a Script Transformation of a Data Flow. Going into the script code (editing Script transformation and clocking "Design Script" button), I try to "Add Reference" to the component (Add Reference selection under "Project" menu), but I do not see ...
Hello folks. SSIS - Lovin it! I have a couple questions/comments:Nov 7th is a long ways away. Ideally, I'd like to convert my current ETL over to SSIS immediately and begin running in production and work around the current bugs. Yeah, I know its unsupported, but it would be nice to be ahead of ...
Hi,I'm using Beta 2 and I've noticed a difference in behavior between VS2005 and VS2003 when generating SQL scripts from database objects in Server Explorer. In VS2003, scripting a table results in separate files (TAB, KEY etc) for the table, indexes and so on. With VS2005 I just get one ...
512 byte By
krog at 2008-2-14
Hi, Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package. Running... Microsoft SQL Server 2005 - 9.00.1116 (Intel ...
First off, I am still on the April CTP.We have a lot of tables and views in one database. I would like to be able to type into the drop down to get myself quickly to the range of tables I am looking for. For example we have a set that are prefixed with sis_But when I try, I get seemingly random ...
I want to let everybody know that I published first build of my ExtraSort component on http://www.ivolva.com/extrasort.html. Everyone on this forum is invited to download and send feedback. It's a plug and play replacement for stock sort transformation. Its goal was handling large data sets ...
Can we pass variables to SSIS package. Which means that we send the values while executing package and use those values inside the package to accomplish some logic.
428 byte By
VivSas at 2008-2-12
In MSDE sql server 2000 dtsrun was available to execute the dts packages but now with sql server 2005 express edition integration service is not part of express/workgroup edition and the dtsexec run time is also not available.Can anyone tell me what my options are other than using different ...
I defined a variable called "NoOfRecords" for a Data Flow Task and within the Data Flow Task I am outputting records from Flat File to RowCount before doing anything else. I typed Variable name as "NoofRecords" in Advanced Editor for Row Count and it didnt like it. It gave the following ...
312 byte By
GiriT at 2008-2-10
Any tips on how to deal with pipeline buffer leaks that are appearing when looping round a package multiple times. Also any information on whether tweaking DefaultBufferRows / Size or threads would be helpful...(this is all stuff that either worked or wasn't as bad in the Dec CTP.. so much for ...
837 byte By
GiriT at 2008-2-10
Just upgraded to the June CTP and having problems executing packages that loop using a For Loop. The first pass is fine but when trying the second we get: Error: 0xC0208296 at LeaseFact Update, Sort 2 [5197]: The input buffer could not be cloned. An out-of-memory condition occurred or there ...
Hello, How can I import data into SQL server via http server ? Thanks
Every time DTEXEC.EXE crashes, SQLDUMPER.EXE process pops up and quickly exits. But I would like my JIT debugger to attach like it happens with other processes. Possible to do? Please inform how.. Thanks.
Hi guys,The ability to run a task in isolation (right-click on a task, select "Execute Task") is fantastic.But, what if I want to run a subset of all the tasks in a package? My only option is to disable all the tasks that I don't want to execute and then execute the package.How about when ...
Every time I try to us a recordset destination for error output, I have problems with setting the "VariableName" field. Is this a known issue? Or am I just doing something wrong? Thanks Jim
72 byte By
sbj at 2008-2-7
what kind of difficulty we find by transfering data from db2 to sql 2005
I am getting strange error on deploying ssis package to SQL Server. TITLE: Package Installation Wizard- Could not save the package "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\Integration Services Project1\Integration Services ...
I have a flat file with several columns and maybe half a dozen rowsI want the value of the first column of the last row captured in a package variable for other processing. In the old DTS I ran the data through a transformation from the flat file to a dummy table in tempdb and captured the ...
I want my package to return the results to the MSMQ queue. from where it will be picked by another application. How do we do that. Do u suggest using service broker for that. in that case how to connect that application to ssis service broker?
I have deployed a package on my local sql server. How do i write a stored procedure to execute it. I want an application to call the stored procedure which executes this package which in turn returns some results.I have dont this by deploying package on filesys and using dtexec.exe command ...
In BI Dev Studio, I have a Project/Solution created successfully, which has got say 5 packages working fine. I created a new package by Right Clicking on a solution explorer and selecting "New SSIS Package". System has given itself a default name and I decided to leave the BI Dev Studio WITHOUT ...
If I have created variable and have written expression etc and then I have realised that I have created it in the wrong place. For example I have created the variable inside Package scope instead of Foreach Loop scope. Yes I know it is my mistake.Do you think it would be nice to have a feature ...
I am exporting records with errors to Excel using the Excel Destination tool. The ErrorColumn is a numeric. How do I find out which column it is?
Hi, Is there a sample or anything that shows what the best way of exporting SQL data to XML? Thanks, David