Viewing 15 posts - 12,346 through 12,360 (of 13,849 total)
You can't easily parse that. I'd bring all the rows in to a single Varchar field and then use T-SQL to parse it.
If you want to exclude rows depending on...
January 8, 2010 at 11:22 pm
Gkhadka (1/8/2010)
... and use JOHN command in ur update SQL code.
Wow, did Mr Rowan get his own command? 😎
January 8, 2010 at 11:13 pm
Sounds to me like you are asking someone here to provide you with a working solution. That's not really how this forum works - people here will provide you with...
January 8, 2010 at 2:14 am
jyoti_bhatt (1/5/2010)
Name Address Phone Age
aaa bbb ...
January 5, 2010 at 9:55 am
Can you provide an example - just 3 or 4 rows - showing what you mean exactly by "blank with no data"? Can a column be "blank with some data"?...
January 5, 2010 at 9:24 am
Much easier - I always choose CSV over Excel, given the option.
January 4, 2010 at 3:50 pm
User::FileName
and it's case-sensitive.
January 2, 2010 at 11:31 am
Trick? 🙂
Why not use Windows Authentication - as desired - but have a File System task that runs first to copy the file to the local server? Then run your...
December 31, 2009 at 11:00 am
Dataflow with appropriate source and target connections.
December 31, 2009 at 2:35 am
It seems that you are not alone in having this problem. One solution might be first to copy the text file to a local drive on the server & then...
December 31, 2009 at 2:33 am
OK, I just read this a bit more carefully.
Can you confirm that the number of columns in the datasource and their names and their data types are always the same...
December 31, 2009 at 2:20 am
As Sabya suggested, please read up on the SCD component and then post back with any additional questions.
December 30, 2009 at 9:59 am
You chose ... wisely.
December 30, 2009 at 9:39 am
Could the column names in the external text file be changing?
December 30, 2009 at 9:25 am
a.hadss (12/30/2009)
in the database:
table one: Customer(ID, Name, Age, Location_ID)
table 2: Location(ID, LOC_NAME)
in a datawarehouse:
table 1: Cust(ID, Name, Age, Location_Name)
now i want to refresh the dataware...
December 30, 2009 at 9:22 am
Viewing 15 posts - 12,346 through 12,360 (of 13,849 total)