Forum Replies Created
Viewing 15 posts - 661 through 675 (of 5,111 total)
-
Reply To: Are the posted questions getting worse?
Don't you just love it when you get a "urgent" work request that needs to be done "NOW", because it's impacting staff productivity, so you get the work done in...
-
Reply To: Are the posted questions getting worse?
Phil Parkin wrote:Seems like the spam is ramping up again.
All the bots are on holiday from Thanks Giving, so they need something else to do with their time. 😉
-
Reply To: Are the posted questions getting worse?
Jo Pattyn wrote:Given it is RTM, I would at least expect that the installer works or notifies about the requirements
Have a look at the installation logs; they are far more verbose...
-
Reply To: Are the posted questions getting worse?
Grant Fritchey wrote:Spin up containers. Easier, faster. Or, a VM on Azure. Again, easier & faster. Especially just for testing stuff out.
Have to agree that using a Container makes things so...
-
Reply To: SSIS 2016, cannot bulk load
Cross post, and I repeat my comment from there: https://stackoverflow.com/questions/58961759/sql-server-integration-services-2016-error-cannot-bulk-load-xml-file
-
Reply To: power shell script for add datetime to file
DinoRS wrote:(and for me begs a different question whose answer is probably well documented - how would you get full month names in this context?) .
That would be
MMMM: -
Reply To: power shell script for add datetime to file
DinoRS wrote:I have never met a 3 digit month before
MMMnotation for a month means the first 3 characters of the name of the month?mandd, etc,... -
Reply To: Flat file source to destination table is getting only top 1 record into table
Agreed, a Script Component is what you want, not a Script Task; the 2 are distinctly different (1 for use in the Control Flow the other the Data Flow)....
-
Reply To: I am new to SQL world
Jeff Moden wrote:Just remember that the YYYY-MM-DD formats aren't actually followed as ISO in SQL Server even though it is a valid ISO format. For example, if you set the language...
-
Reply To: Flat file source to destination table is getting only top 1 record into table
123456|20130701|AWD|WS1035575|20170201|VCDF|MA1064844|20110001|NHS|AS19474754|20160401|EFV7|LK
Is more than 4 columns. What is your row delimiter here, the 4th
|character? If so, can you change that? Using a row delimiter that's the... -
Reply To: I am new to SQL world
Kabina wrote:This is backend tables are on SQL server where I got access to retrieve data where datatype for POdate is nvarchar(48).
That doesn't explain the data type choice. A
varchar... -
Reply To: I am new to SQL world
This is pseudo-SQL, but seems like you'd be better off with a start and end parameter, which you set at the start of the batch:
DECLARE @StartDate date...
-
Reply To: I am new to SQL world
Jeff Moden wrote:Thanks, Thom. Understood on the 2019 stuff. I was under the impression that it wasn't actually a "4th" type... I was under the impression that if SQL Server could...
Viewing 15 posts - 661 through 675 (of 5,111 total)