Viewing 15 posts - 9,421 through 9,435 (of 13,876 total)
Narly254 (1/23/2014)
Thank you It took some time but that helped a lot!
Well done. Quality coding takes time, but pays off in the long run 🙂
January 23, 2014 at 9:55 am
I have just downloaded SQLEnlight and started evaluating it and would be interested to hear any other comments about this product. My intention is to use it primarily for static...
January 23, 2014 at 8:41 am
Koen Verbeeck (1/23/2014)
You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.
+1
January 23, 2014 at 3:45 am
I'm using a simple set up. Excel Source---Data Conversion (for the routing ID column) and an OLE DB Command
If anyone knows a work around or knows exactly how to fix...
January 22, 2014 at 12:39 pm
nonghead-webspam (1/17/2014)
January 20, 2014 at 1:04 am
Have a look here for an example of importing multiple files with the same format.
January 18, 2014 at 5:33 am
But I was actually looking for a multi-tab csv since I am able to add worksheets/ tabs to a csv file manually
Please post an example of one of these.
January 16, 2014 at 1:22 am
kenneth.mofokeng (1/16/2014)
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
...
January 16, 2014 at 1:20 am
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...
January 16, 2014 at 12:20 am
mpradeep23 (1/15/2014)
hii want to find count of rows in all tables in database based on created
thanks in advance,
Pradeep
OK, please provide some sample data, DDL and desired results in...
January 16, 2014 at 12:10 am
polkadot (1/14/2014)
January 15, 2014 at 12:28 am
polkadot (1/14/2014)
For now I've removed the EID...
January 14, 2014 at 10:24 am
DaveDB (1/14/2014)
Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own...
January 14, 2014 at 8:21 am
DaveDB (1/13/2014)
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...
January 13, 2014 at 10:43 pm
ducon (1/13/2014)
I was commenting on the old post about the need to troubleshoot and debut packages...
January 13, 2014 at 10:03 pm
Viewing 15 posts - 9,421 through 9,435 (of 13,876 total)