Viewing 15 posts - 4,351 through 4,365 (of 13,855 total)
OK, try this version:
INSERT INTO OPENQUERY
(LINKSERVER1
,'select virtuemart_category_id, category_name, category_description, metadesc, metakey, CustomTitle, slug, ERPCode from rszcf_virtuemart_categories_el_gr'
)
(
virtuemart_category_id
, category_name
, category_description
, metadesc
, metakey
June 7, 2018 at 6:28 am
June 7, 2018 at 6:25 am
But it's not working.
While Importing data from Input file to the derived...
June 7, 2018 at 5:21 am
June 7, 2018 at 5:12 am
June 6, 2018 at 11:37 am
June 6, 2018 at 11:34 am
June 6, 2018 at 11:13 am
Found out what the problem is.
My PC is hosed. Something (we're not sure what)...
June 6, 2018 at 10:26 am
Use a Conditional SSIS Expression to do this.
June 6, 2018 at 10:23 am
Could the pre-2018 tables be loaded using a backup of the db on a separate server?
June 6, 2018 at 9:12 am
June 6, 2018 at 7:36 am
June 5, 2018 at 1:30 pm
The SQL Server table is not the problem here.
Check the Advanced properties for your Flat File Source component and check the input and output columns.
June 5, 2018 at 12:24 pm
June 5, 2018 at 10:27 am
Viewing 15 posts - 4,351 through 4,365 (of 13,855 total)