Viewing 15 posts - 5,431 through 5,445 (of 7,185 total)
The correct string length will be returned. Try the code in the attached file.
John
April 7, 2011 at 9:13 am
What you've got should work - just change varchar(@Length) to varchar(1000). Not sure why you need a UDF, though - the built-in function LEFT should do exactly what you...
April 7, 2011 at 8:55 am
If you have SQL Server Agent running under a local account then you can't do it. You need to run it under a domain account.
John
April 7, 2011 at 1:28 am
Is the destination table on a separate instance? If so, check that the SQL Server Agent account (or a Windows group of which it is a member) is set...
April 6, 2011 at 9:18 am
Sounds like it might be an issue with permissions. I take it when you say "scheduled", you mean it runs as a SQL Server Agent job? If so,...
April 6, 2011 at 8:51 am
You could try an outer join, or you could look at the EXCEPT operator. As ever, you'll want to to test each one against your own data to see...
April 6, 2011 at 7:10 am
You can find view definitions in the sys.sql_modules system view.
John
April 6, 2011 at 6:51 am
Sanz
Perhaps you are supplying different parameters, or maybe your connection settings are different (things like SET ANSI_NULLS). Different connection providers (ODBC, OLEDB and so on) have different default settings.
John
April 6, 2011 at 3:22 am
Naru
No, do not have tables with different structures processed by the same data flow. Please post your code - I'm finding it very difficult to visualise.
John
April 6, 2011 at 1:57 am
OK, I found a table with only one index, which is non-clustered. The table has 400000 rows and the fragmenation of the index was 57.9%. I rebuilt the...
April 5, 2011 at 9:59 am
Naru
You need to make sure that the collection for each loop only contains the files you want to be processed by the dataflow within that loop. One way to...
April 5, 2011 at 8:24 am
CirquedeSQLeil (4/5/2011)
You can rebuild the NC but fragmentation will persist. A clustered index is required to defrag the NCs.
Jason, I must confess I don't understand. What's the difference...
April 5, 2011 at 8:19 am
As I said before, you shouldn't get too many problems if you only do inserts, although I can't guarantee that. One problem you will have is that your database...
April 5, 2011 at 8:02 am
If you've set up your loops correctly, it will load each text file for the same table one by one. As I said before, I can't tell you what's...
April 5, 2011 at 7:52 am
Viewing 15 posts - 5,431 through 5,445 (of 7,185 total)