Viewing 15 posts - 271 through 285 (of 417 total)
Are you trying to execute multiple packages sequentially from a single execute package task?
If so then I think your execute package task needs to be in a for each loop...
May 23, 2022 at 7:16 pm
Edit: What they said.
It may be that the drive is mapped for your user, but not the SQL Service account, or whatever account the GUI uses.
Have you tried writing a...
May 18, 2022 at 5:03 pm
B - local machine administrator account is not an admin
When we have a new server (aws so we create and delete them fairly often) and I am a local...
May 7, 2022 at 6:23 pm
Do you ever have more then 2? This works for any number, you just need the count number to match the number of IN values. You said you were building...
May 6, 2022 at 3:05 pm
If the tables join on SalesID and SalesID is unique in both tables, I would probably start by joining the tables and creating a match column for each column and...
May 3, 2022 at 9:56 am
Why do you have a left join? it seems you could change it to an inner join. I don't know what that would do to the execution plan, but I...
April 27, 2022 at 9:56 pm
The answer is probably truncate, but both will work.
You can not truncate a table that is referenced by a foreign key constraint, but it seems likely the student_course has relationships...
April 27, 2022 at 8:03 pm
What date does DtKey mean and why do you need to filter it as well as the createdate. ? How does DtKey represent a date?
Does it join to a calendar...
April 27, 2022 at 5:35 pm
Rather than adding a month and taking away a day to get the end of month (which is how I have always done it) there is a function called EOMONTH...
April 22, 2022 at 7:34 pm
Why do you have to wake up early to truncate some tables? Can't you schedule the truncates before they start their push? If you don't have permissions to create a...
April 18, 2022 at 10:18 pm
HI Expert,
insert into test values
('2022-01-04 18:00:57','Newone','segmentone'),('2022-01-04 19:00:57','Newone','segmenwo'), ('2022-04-04 18:00:57','Newtwo','segmenthee'),('2022-04-04 19:00:57','Newtwo','segmenfour')
Your table has a DATE data type. Try changing it to DATETIME.
April 18, 2022 at 3:33 pm
Do you see SSISDB if you expand "Integration Services Catalogs" ?
https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/
Do you need to create a catalog before the db exists?
I don't know if the OP needs the...
April 18, 2022 at 3:11 pm
Does this get what you need? I would avoid using reserved words as column names (status and value).
Some people prefer to use a CTE, but I like derived tables.
April 14, 2022 at 7:40 pm
Thank you for this. I had to work out what a table was and then it just worked. I thought I had skills in building sql statements using stacked concatenate...
March 29, 2022 at 11:57 pm
I understand the risk. This is a stop gap until I can rework the SQL Job to avoid it. The reason it would fail is due to server load...
March 28, 2022 at 5:39 pm
Viewing 15 posts - 271 through 285 (of 417 total)