Viewing 15 posts - 3,001 through 3,015 (of 7,187 total)
The subject line is the subject line - why would you want to put information like that in it? If you really want to, you can, but your requirement...
October 14, 2015 at 7:38 am
If you're running the package interactively (in BIDS/SSDT), you'll be able to see the error messages and work it out from there. If it's running from a job or...
October 14, 2015 at 3:16 am
SSIS packages are designed to run unattended, not interactively, so don't use message boxes - they'll make your package fail as soon as you schedule it. Have you tried...
October 14, 2015 at 3:11 am
This is something that you'd normally handle in your presentation layer, front end, application - call it what you will. It's the kind of thing that Reporting Services can...
October 13, 2015 at 9:13 am
SSIS, OPENROWSET, linked server... it depends on your requirements.
John
October 13, 2015 at 4:08 am
Bring everything from the flat file into a staging table and do the checks there.
John
October 13, 2015 at 4:04 am
For proper help, please post table definitions (CREATE TABLE statements), execution plan, the CREATE TYPE statement for your dbo.TableVariable9 and the T-SQL you use to call the stored procedure. ...
October 13, 2015 at 2:26 am
Dave
Shrinking your database won't have any effect on the size of the backup, only the size of the database files.
1. Have you tried ALTER TABLE MyTable ALTER COLUMN MyColumn...
October 13, 2015 at 2:15 am
BULK INSERT doesn't take parameters in the form -U, -P and -c. I think you're getting confused with bcp.
John
October 9, 2015 at 6:18 am
SSIS is as good a tool as any. Other methods are available - linked servers, OPENQUERY and so on. You pay your money, you take your choice.
You'll use...
October 9, 2015 at 2:51 am
Knut
You need an outer join.
SELECT
r.Recipe_number
,r.Recipe_name
FROM tblRecipe AS r
LEFT JOIN tblRecipeAllergen AS a
ON r.Recipe_number = a.Recipe_number
AND a.Allergen = 'Milk'
WHERE a.Recipe_number IS NULL
John
October 7, 2015 at 4:32 am
He didn't pass the parameters in, though - they're all output parameters. The values were got from the tables.
John
September 25, 2015 at 10:01 am
How have you tried making the whole thing dynamic? Did you use sp_executesql? Please will you post what you tried?
John
September 25, 2015 at 9:34 am
Sean, I think he's wanting to insert the values into tblVoting, and at the same time return the inserted values as output parameters. Obviously that'll only work if that...
September 25, 2015 at 9:07 am
Are you doing transaction log backups? How often? There's no need to change to simple mode and back again - just back up the log and shrink it...
September 25, 2015 at 8:46 am
Viewing 15 posts - 3,001 through 3,015 (of 7,187 total)