Have a look here for an example of importing multiple files with the same format.

Please post an example of one of these.

kenneth.mofokeng (1/16/2014)

---

try this , u can change it and use sp_msForEachDB to loop around all databases

SELECT sc.name +'.'+ ta.name TableName

,SUM(pa.rows) RowCnt

FROM sys.tables ta

INNER JOIN sys.partitions pa

...

It's quite advanced, especially given your experience with the product, but this article is relevant.

Also, as others have mentioned, please stop referring to multi-tab CSV files: they do not and...

OK, please provide some sample data, DDL and desired results in...

polkadot (1/14/2014)

---

Actually, that's what I meant. I have nothing in the CollectionString property. I should not have said that I added the variable to the ConnectionString property, rather I...

polkadot (1/14/2014)

---

I did answer Montana Life's questions. Not like me not to. Oh Oh Phil, Do you need to have your eyes checked? 😛

For now I've removed the EID...

DaveDB (1/14/2014)

---

Simple enough Phil.... And I didn't need a unicycle 🙂

Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own...

DaveDB (1/13/2014)

---

Hi Phil,

Nice to see you again 🙂

I just need to know what the syntax is to include weekends based on a simple date range. Not sure why you would...

ducon (1/13/2014)

---

Your powers of observation are quite strong despite the look of your profile pic ;).

I was commenting on the old post about the need to troubleshoot and debut packages...

You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get...

Lempster (1/13/2014)

---

Phil Parkin (1/12/2014)

Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not...

ducon (1/13/2014)

---

You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where...

polkadot (1/12/2014)

---

I installed BIDS 2012 but I think it just integrates Visual Studio 2010 within it's shell, and in my case it detects my 2010 packages but when I try...

Thanks for getting into deeper

Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there...