Normally, you can do all of these tasks quite easily with SSIS.

1. Use OLE DB Sources to connect to the various databases. Specify the SQL statement to select the data...

The size of the varbinary(max) should be no problem, as varbinary(max) allows up to 2^31-1 bytes. (see http://msdn.microsoft.com/en-us/library/ms188362.aspx). MSDN even says that varbinary(max) is suffice for a replacement of the...

Good question, although not that hard (for 2 points).

erajendar (5/13/2010)

---

It is very interesting. However, am still not clear on [flag ='y' ]. Can someone tell me what is...

Nice question. And not so easy...

Read this article:

http://sqlblog.com/blogs/jamie_thomson/archive/2010/03/31/filenamecolumnname-property-flat-file-source-adapter-ssis-nugget.aspx

If you are using the Flat File Source, you can directly store the filename in a column. If you only need the filepath and the filename in seperate...

You could store the error in a variable. Store the results of your dataflow task in a temporary table.

Then, after the data flow task has finished, use a script task....

I think he was referring to my comment where I stated that the data profiling taks, according to BOL, only works with ADO.NET and with SQL Server 2000 or up....

I don't think you can use any other connection besides ADO.NET:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a9501955-adf2-4735-958a-f170a58fcc61/

or

http://technet.microsoft.com/en-us/library/bb895310.aspx

The solution: buy another product :-D:-P

Because sql server 2005 comes with Integration Services (SSIS) and it will always output .dtsx files.

If you want .dts files, you'll have to install SQL Server 2000 (or older? I...

No, I guess you didn't. SSRS is part of the Business Intelligence suite of SQL Server and since this is the forum Business Intelligence, you are probably correct of posting...

I have no idea. I have never used SSRS before 🙂

I'm more of a SSIS/SSMS/SSAS user.

I've read similar questions like this one on this forum, but I've never seen an answer. (maybe I stopped checking the thread too early :-)).

So I guess that it is...

To give a little more explanation:

DTS is the old version of SSIS. DTS uses .dts files, SSIS uses .DTSX files.

You can compare it with .xls for Excel 2003 and .xlsx...

Try placing brackets around the different logical parts of your OR statement.

Now you have:

WHERE something1 AND something2 ...

OR

somethinga AND somethingb ....

OR

...

Try the following:

WHERE (something1 AND something2 ...)

OR

(somethinga AND somethingb ....)

OR

SSIS and metadata refreshing :unsure:

I hope they do something about it...