Showing posts with label business. Show all posts
Showing posts with label business. Show all posts

Wednesday, March 21, 2012

importing flat files to many tables

I'm trying to input a few thousand flat files into a few thousand tables in a sql database, using SQL Server Business Intelligence Development Studio.

im using a for each loop to read all the files in a directory

the problem is i can only insert the data from all the files into one table

does anyone know a way to do multiple tables? maybe using some sort of variable?


Use the multicast in the dataflow.

Kirk Haselden
Author "SQL Server Integration Services"

Sunday, February 19, 2012

importing a pdf file

I have a business objects report that I would like to set up in reporting
services. I'm wondering if there is a way to import or display a link to a
.pdf file in reporting services.
Any ideas?
ThanksThere's no way to "import" PDFs, but you can include hyperlinks to external
PDF documents in Reporting Services' reports.
Best,
-Chris
SQL Server Reporting Services
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:82D55264-C23D-41D5-A809-4A838C334518@.microsoft.com...
>I have a business objects report that I would like to set up in reporting
> services. I'm wondering if there is a way to import or display a link to
> a
> .pdf file in reporting services.
> Any ideas?
> Thanks