Show an SQL Server Integration Services Raw File in a Datagridview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all

I want to give administrators of a datawarehouse a possibility to have a
look at the extracts of the source systems a SSIS Packages puts in a
datawarehouse.

I thought the best way would be to let the package generate an Raw file
with the extract and write a .NET windows application to show this SSIS RAW
File in a .NET 2.0 DataGridView.

Unfortunately I could not find out how this works.

Can you please point me to the right direction?

Thanks, Marc


Regards,

Marc
 
Hi Roger,

Thanks for your post!

Sorry, I am not familiar with SQL Server Integration Services.

In .Net winform concept, it does not deal with DataBase directly, it just
operates with .Net data source types. So if you know the format of the raw
file, we can use .Net I/O classes to read the raw file to form a .Net
dataset instance. Then we can use .Net DataGridView control to bind to this
dataset.

Hope this helps

Best regards,
Jeffrey Tan
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Jeffrey

I just tried to post this task of mine in this forum as well as in the
sqlserver.dts
forum, because both subjects are affected :-)

I found out that raw files from SSIS are not for human eyes so I decided to
use text files with a Microsoft.Jet.OLEDB.4.0 provider, which worked fine.


Best regards,

Marc
 
Hi Marc,

Do you mean that you have got the problem resolved? If you need further
help, please feel free to post. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top