Help on creating SSIS

Hello ,

I am getting the given error message while creting SSIS. Please help me to solve the error....

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

regards,

Malhar , THanks

Where do you see the error message?|||

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Plz help me out if u can..

Thanx n Regards,

Malhar

|||

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

Plz help me out if u can..

Thanx n Regards,

Malhar

|||If all you're doing is creating a brand new project and this error appears before you've done anything then it sounds like you've got a corrupt installation. Unfortunatly I'm not able to offer any meaningful help other than trying to reinstall the SQL 2005 Client Tools|||

Hi,

Thanx for ur reply.

Yup i m creating brand new project and as soon as i create new project this error comes.

Well, whatever solution u have mentioned, is the only solution? and after reinstalling sql server 2005, my problem wud b solved?

Thanx n Regards,

Malhar

|||

hi,

Thanx for ur reply.

Yup i m creating brand new project and as soon as i create new project, that error comes.

Well, Whatever solution u have mentioned, is the only solution? My problen will get solved if i wud reinstall MS Sql Server 2005?

or is there any other solution available? Whts the meaning of that error : Failed on the unmanaged server..

Thanx and Regards,

Malhar

|||

malhar wrote:

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

Plz help me out if u can..

Thanx n Regards,

Malhar

I'm not sure what's causing your issue, but it's possible that your SSIS installation has become corrupted. The only solution I can think of is to do a fresh install.|||

This looks like it may be a problem related to InstallShield. I just received the same error opening an existing SSIS project. Here is a link to what may be a solution

http://support.installshield.com/kb/view.asp?articleid=q106194

Help on creating SSIS

Hello ,

I am getting the given error message while creting SSIS. Please help me to solve the error....

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

regards,

Malhar , THanks

Where do you see the error message?|||

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Plz help me out if u can..

Thanx n Regards,

Malhar

|||

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

Plz help me out if u can..

Thanx n Regards,

Malhar

|||If all you're doing is creating a brand new project and this error appears before you've done anything then it sounds like you've got a corrupt installation. Unfortunatly I'm not able to offer any meaningful help other than trying to reinstall the SQL 2005 Client Tools|||

Hi,

Thanx for ur reply.

Yup i m creating brand new project and as soon as i create new project this error comes.

Well, whatever solution u have mentioned, is the only solution? and after reinstalling sql server 2005, my problem wud b solved?

Thanx n Regards,

Malhar

|||

hi,

Thanx for ur reply.

Yup i m creating brand new project and as soon as i create new project, that error comes.

Well, Whatever solution u have mentioned, is the only solution? My problen will get solved if i wud reinstall MS Sql Server 2005?

or is there any other solution available? Whts the meaning of that error : Failed on the unmanaged server..

Thanx and Regards,

Malhar

|||

malhar wrote:

Hi,

Error is coming in Error List...

When i open new project->Integration Service Project.. I see the Package.dtsx with the following error

Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..

Plz help me out if u can..

Thanx n Regards,

Malhar

I'm not sure what's causing your issue, but it's possible that your SSIS installation has become corrupted. The only solution I can think of is to do a fresh install.|||

This looks like it may be a problem related to InstallShield. I just received the same error opening an existing SSIS project. Here is a link to what may be a solution

http://support.installshield.com/kb/view.asp?articleid=q106194

Help Needed in Approach for Error Output In SSIS

Hi i have a issue i am loading data from a flat file into a relational Database and i am loading the data without dropping the Primary and Foreign Key constraints and i am sending the error rows into a error table for each table. This is becoming large over head is there a way to Load the entire error Row as a single Column in one Error Table.

This is occuring coz the input is being parsed and its dividing into columns,

One approach would be to used Derived Column Transformation and Substring all columns but it makes to writing long substring statement as some tables have 80 columns ,

is there a better way to handle these errors so that they can be looked at and Changes can be made to the Data ,

Also one more question is is there a way to Load in case of Duplicates load only the Recent Row By Date Column.

and send the old row according to Date into Error output.

Please suggest me what approach should i go for

Not really

You are best to create individual error tables. It means its easier for the user to see what the data is because it will be correctly split up.

|||

For your first question - why not use a error table with "row number" and "table name" columns and then rather than dumping the whole row into the error table -- log the row number and table name so that you can go back to the exact row and find the data you are having problem with. As the error table now has a standard structure (2 columns), you can use the same error table for logging errors for all the tables you are loading.

For you second question - You are trying to clean up the data (De-Duplication) so its better to stage the tables you are having duplicates in and then load it into the database after deleting the duplicate rows. This is hard to be done in the data-flow task because the order of the data coming in might not be based on date.

|||Another approach to de-duping rows is to use the Rank function - You can find an example using T-SQL here: http://rafael-salas.blogspot.com/2007/04/remove-duplicates-using-t-sql-rank.html and one with a custom component here: http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Rank-Transform.aspx

On the single column to capture an error, I have seen this implemented by using a text or xml column and generically creating the string to insert based on the row data. However, as Simon noted, this isn't typically very readable, and may require a seperate application to support reviewing the errors.

|||

is there way to log the record number in the Flatfile where the error is occuring and is there a way to log the Error Code and Error Description . Can u please guide me regarding this.

|||I need to capture the Database, Table, Input File Name, Input File Record Number; Key Data (does not need to be entire record), Error Code, Error Desc, Date and Time, SSIS Package/Program|||Basically you need to generate a rowNumber column in the dataflow. There are some samples:

http://support.microsoft.com/kb/908460

http://www.sqlis.com/93.aspx|||Thanks for the information it was very helpful i was thinking to capture the sorce filename and Destination table name too into the error table is there a way to capture this information.|||If you store those values in variables, you can use a derived column transform to bring them into the error flow.|||I am aware of this approach but is there way to store these values into variables , my connection managers are Dynamic i.e from a configurations table in sql server. is there way to capture the src and output names atleast in variable s to write it to error table|||

Dev2624 wrote:

Thanks for the information it was very helpful i was thinking to capture the sorce filename and Destination table name too into the error table is there a way to capture this information.

Why are you creating new threads on this topic? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2195648&SiteID=1|||Phil's suggestion in the other thread is the same thing I was going to recommend.

Help Needed in Approach for Error Output In SSIS

Hi i have a issue i am loading data from a flat file into a relational Database and i am loading the data without dropping the Primary and Foreign Key constraints and i am sending the error rows into a error table for each table. This is becoming large over head is there a way to Load the entire error Row as a single Column in one Error Table.

This is occuring coz the input is being parsed and its dividing into columns,

One approach would be to used Derived Column Transformation and Substring all columns but it makes to writing long substring statement as some tables have 80 columns ,

is there a better way to handle these errors so that they can be looked at and Changes can be made to the Data ,

Also one more question is is there a way to Load in case of Duplicates load only the Recent Row By Date Column.

and send the old row according to Date into Error output.

Please suggest me what approach should i go for

Not really

You are best to create individual error tables. It means its easier for the user to see what the data is because it will be correctly split up.

|||

For your first question - why not use a error table with "row number" and "table name" columns and then rather than dumping the whole row into the error table -- log the row number and table name so that you can go back to the exact row and find the data you are having problem with. As the error table now has a standard structure (2 columns), you can use the same error table for logging errors for all the tables you are loading.

For you second question - You are trying to clean up the data (De-Duplication) so its better to stage the tables you are having duplicates in and then load it into the database after deleting the duplicate rows. This is hard to be done in the data-flow task because the order of the data coming in might not be based on date.

|||Another approach to de-duping rows is to use the Rank function - You can find an example using T-SQL here: http://rafael-salas.blogspot.com/2007/04/remove-duplicates-using-t-sql-rank.html and one with a custom component here: http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Rank-Transform.aspx

On the single column to capture an error, I have seen this implemented by using a text or xml column and generically creating the string to insert based on the row data. However, as Simon noted, this isn't typically very readable, and may require a seperate application to support reviewing the errors.

|||

is there way to log the record number in the Flatfile where the error is occuring and is there a way to log the Error Code and Error Description . Can u please guide me regarding this.

|||I need to capture the Database, Table, Input File Name, Input File Record Number; Key Data (does not need to be entire record), Error Code, Error Desc, Date and Time, SSIS Package/Program|||Basically you need to generate a rowNumber column in the dataflow. There are some samples:

http://support.microsoft.com/kb/908460

http://www.sqlis.com/93.aspx|||Thanks for the information it was very helpful i was thinking to capture the sorce filename and Destination table name too into the error table is there a way to capture this information.|||If you store those values in variables, you can use a derived column transform to bring them into the error flow.|||I am aware of this approach but is there way to store these values into variables , my connection managers are Dynamic i.e from a configurations table in sql server. is there way to capture the src and output names atleast in variable s to write it to error table|||

Dev2624 wrote:

Thanks for the information it was very helpful i was thinking to capture the sorce filename and Destination table name too into the error table is there a way to capture this information.

Why are you creating new threads on this topic? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2195648&SiteID=1|||Phil's suggestion in the other thread is the same thing I was going to recommend.

help me! my mssql 2000 server (with sp3a) is keeping full loading my cpu non-stop now!

my mssql never be used much
and i had a firewall to blocked the port of mssql to internet

but i don't that why tonight the sql server non-stop keep full loading the cpu suddenly until now!
please help meSQL Server 2000 SP3a is nothing but 10.5 megs of Transact code, if you send me an email with the in my profile I can help you with it. That is some of the most clean and close to ANSI SQL code I have seen from Microsoft. You may want to ignore some of the questions Windows ask you answer only those relevant to you. I write ANSI SQL, Transact-SQL, Java and C#. Hope this help.

Kind regards,
Gift Peddie|||do u have any msn messenger then?|||No I don't do messengers, what I can tell you is there are 25 files and Windows will only execute the files applicable to you because only 11 files were executed on my Windows 2003 Enterprise Server that was not part of a network. But with SP3a I was able to install Reporting Services and Analysis Services without problem and I had Visual Studio 2003 on the box before SP3a. Hope this help.

Kind regards,
Gift Peddie